Generic Searching with SQL
Example 10 - Rating: common
Example 10 - Rating: common
| The Things that Make Up this Example | To Execute this Example |
This example demonstrates generic search using the LANSA SELECT_SQL command with a variable search value. Additionally it shows how the SQL LIKE comparison can be used. This example works on both the iSeries and PC. A common use for this technique would be text searching.
The example function uses the Personnel System demonstration material. It shows how to locate all employees whose employee number matches a specified string.
Notes and suggestions
Note all the restrictions on the name and length of field #SETCND in the example.
In PC environments, if there is no PSLMST file in library DC@DEMOLIB, this function will need to be recompiled before being run.
Keywords
The example function uses the Personnel System demonstration material. It shows how to locate all employees whose employee number matches a specified string.
Notes and suggestions
Note all the restrictions on the name and length of field #SETCND in the example.
In PC environments, if there is no PSLMST file in library DC@DEMOLIB, this function will need to be recompiled before being run.
Keywords
| SELECT_SQL | Text searching |
| LIKE | Example 10 |
| Searching |