ALLBASE/SQL Reference Manual (36216-90216)

606 AppendixA
SQL Syntax Summary
ENABLE AUDIT LOGGING
ENABLE AUDIT LOGGING
ENABLE RULES
ENABLE RULES
END DECLARE SECTION
END DECLARE SECTION
EXECUTE
EXECUTE{ StatementName
[ Owner. ] ModuleName [( SectionNumber )]}
[USING{[SQL] DESCRIPTOR{[INPUT]{SQLDA
AreaName1 }
[AND OUTPUT {SQLDA
AreaName2 }]
OUTPUT {SQLDA
AreaName }}
[INPUT] HostVariableSpecification1
[AND OUTPUT HostVariableSpecification2 ]
OUTPUT HostVariableSpecification
: Buffer [,: StartIndex [,: NumberOfRows ]] }]
HostVariableSpecification
: HostVariableName [[INDICATOR]: IndicatorVariable ] [,...]
EXECUTE IMMEDIATE
EXECUTE IMMEDIATE { ‘String’
:HostVariable }
EXECUTE PROCEDURE
EXECUTE PROCEDURE [: ReturnStatusVariable = ][ Owner. ] ProcedureName
[([ ActualParameter ][,[ ActualParameter ]][...]) ]
ActualParameter
[ParameterName = ]ParameterValue [OUTPUT[ONLY]]
FETCH
[BULK] FETCH CursorName {INTO HostVariableSpecification
USING{ [SQL] DESCRIPTOR {SQLDA
AreaName }
HostVariableSpecification } }
BULK HostVariableSpecification
: Buffer [,: StartIndex [,: NumberOfRows ]]