The Things that Make Up this Example
From LANSA
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 |