SQUARE ROOT

LANSA

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

Function SET189L or form S_189FL

You can use mathematical functions such as square root to manipulate the retrieved data:


SELECT_SQL FIELDS(#SALARY (#MNTHSAL 'SQRT(SALARY)')) FROM_FILES((PSLMST))




TypeNameCodeDescription
FunctionSET189LSET189LSELECT_SQL - SQRT (Square root)
Form S_189FLS_189FLSELECT_SQL - SQRT (Square root)