Generic Searching with SQL

LANSA

Generic Searching with SQL
Example 10 - Rating: common
The Things that Make Up this ExampleTo 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
SELECT_SQLText searching
LIKEExample 10
Searching