ANY
All about SELECT_SQL | The Things that Make Up this Example | To Execute this Example | Forms/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.
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.
Function | SET189G | SET189G | SELECT_SQL - Sub-select ANY |
Function | SET1891 | SET1891 | PC version of SET189G |
Form | S_189FG | S_189FG | SELECT_SQL - Sub-select ANY |