Calculation

LANSA

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

Function SET189B or form S_189FB

You can use the SELECT_SQL statement to perform calculations on the retrieved data:


SELECT_SQL FIELDS(#SURNAME #SALARY (#STD_AMNT 'SALARY * 1.10')) FROM_FILES((PSLMST))




TypeNameCodeDescription
FunctionSET189BSET189BSELECT_SQL - Calculation
Form S_189FBS_189FBSELECT_SQL - Calculation