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 |