The Things that Make Up this Example
If you imported the SET example materials, these objects have been created for you in the repository:
Generic Searching with SQL | To Execute this Example |
If you imported the SET example materials, these objects have been created for you in the repository:
Type | Name | Details | Description |
Process | SET_010 | Process for this example. | |
Function | SET010A | Function SET010 | Select employee based on partial employee number |
Field | EMPNO | A 5 0 | Employee Number |
Field | GIVENAME | A 20 0 | Employee Given Name(s) |
Field | IO$STS | A 2 0 | Data base I/O operation status code |
Field | PHONEHME | A 15 0 | Home Phone Number |
Field | POSTCODE | S 6 0 | Post / Zip Code |
Field | STD_CODEL | A 6 0 | Standard CODE LONG |
Field | STD_TEXT | A 50 0 | Standard TEXT |
Field | SURNAME | A 20 0 | Employee Surname |