ANY

LANSA

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

Function SET189G or form S_189FG

Use the ANY parameter to make a subquery:


SELECT_SQL FIELDS(#EMPNO) FROM_FILES((PSLMST)) WHERE('EMPNO = ANY (SELECT EMPNO FROM "XDEMOLIB"."PSLSKL")')



Note that because of slight differences in SQL syntax, there are separate versions of this example for the iSeries and for the PC. The PC version of this example is named SET1891 and the iSeries version is named SET189G.
FunctionSET189GSET189GSELECT_SQL - Sub-select ANY
FunctionSET1891SET1891PC version of SET189G
Form S_189FGS_189FGSELECT_SQL - Sub-select ANY