IN

LANSA

IN
All about SELECT_SQLThe Things that Make Up this ExampleTo Execute this ExampleForms/Components for this Example

Function SET189J or form S_189FJ

You can use IN to retrieve fields that match listed values:


SELECT_SQL FIELDS(#EMPNO #SKILCODE) FROM_FILES((PSLSKL)) WHERE('SKILCODE IN (''4GL'', ''INTRO'')')

Or to exclude fields that match selected values:
SELECT_SQL FIELDS(#EMPNO #SKILCODE) FROM_FILES((PSLSKL)) WHERE('SKILCODE NOT IN (''4GL'', ''INTRO'')');




TypeNameCodeDescription
FunctionSET189JSET189JSELECT_SQL - (NOT) IN
Form S_189FJS_189FJSELECT_SQL - (NOT) IN