The Things that Make Up this Example

LANSA

The Things that Make Up this Example
All about SELECT_SQLTo Execute this ExampleForms/Components for this Example



Objects Required

If you imported the SET example materials, these objects have been created for you in the repository:
TypeNameCodeDescription
FunctionSET189ASET189ASELECT_SQL - Distinct
FunctionSET189BSET189BSELECT_SQL - Calculation
FunctionSET189CSET189CSELECT_SQL - AND and OR
FunctionSET189DSET189DSELECT_SQ_L - NOT
FunctionSET189ESET189ESELECT_SQL - Joins
FunctionSET189FSET189FSELECT_SQL - Joining a file to itself
FunctionSET189GSET189GSELECT_SQL - Sub-select ANY
FunctionSET1891SET1891PC version of SET189G
FunctionSET189HSET189HSELECT_SQL - Sub-select ALL
FunctionSET1892SET1892PC version of SET189H
FunctionSET189ISET189ISELECT_SQL - (NOT) BETWEEN
FunctionSET189JSET189JSELECT_SQL - (NOT) IN
FunctionSET189KSET189KSELECT_SQL - (NOT) LIKE
FunctionSET189LSET189LSELECT_SQL - SQRT (Square root)
FunctionSET189MSET189MSELECT_SQL - Substring
FunctionSET189NSET189NSELECT_SQL - SUM, AVG, COUNT, MAX, MIN
Form S_189FAS_189FASELECT_SQL - Distinct
Form S_189FBS_189FBSELECT_SQL - Calculation
Form S_189FCS_189FCSELECT_SQL - AND and OR
Form S_189FDS_189FDSELECT_SQL - NOT
Form S_189FES_189FESELECT_SQL - Joins
Form S_189FFS_189FFSELECT_SQL - Joining a file to itself
Form S_189FGS_189FGSELECT_SQL - Sub-select ANY
Form S_189FHS_189FHSELECT_SQL - Sub-select ALL
Form S_189FIS_189FISELECT_SQL - (NOT) BETWEEN
Form S_189FJS_189FJSELECT_SQL - (NOT) IN
Form S_189FKS_189FKSELECT_SQL - (NOT) LIKE
Form S_189FLS_189FLSELECT_SQL - SQRT (Square root)
Form S_189FMS_189FMSELECT_SQL - Substring
Form S_189FNS_189FNSELECT_SQL - SUM, AVG, COUNT, MAX, MIN