ALL

LANSA

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

Function SET189H or form S_189FH

You can use the ALL parameter to make a subquery:


SELECT_SQL FIELDS(#EMPNO) FROM_FILES((PSLMST)) WHERE('SALARY > ALL (SELECT SALARY FROM "XDEMOLIB"."PSLMST" WHERE EMPNO < ''A1007'')')

SELECT_SQL FIELDS(#EMPNO) FROM_FILES((PSLMST)) WHERE('EMPNO > ALL (SELECT EMPNO FROM "XDEMOLIB"."PSLSKL" WHERE EMPNO < ''A1234'')')



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 SET1892 and the iSeries version is named SET189H.
TypeNameCodeDescription
FunctionSET189HSET189HSELECT_SQL - Sub-select ALL
FunctionSET1892SET1892PC version of SET189H
Form S_189FHS_189FHSELECT_SQL - Sub-select ALL