ALLBASE/SQL Reference Manual (36216-90216)

610 AppendixA
SQL Syntax Summary
PREPARE
PREPARE [REPEAT]{ StatementName
[ Owner. ] ModuleName [( SectionNumber )]}
[IN DBEFileSetName ]FROM { ‘String’
:HostVariable }
PRINT
PRINT {‘Constant’
:LocalVariable
:Parameter
::Built-inVariable };
RAISE ERROR
RAISE ERROR [ ErrorNumber ] [MESSAGE ErrorText ]
REFETCH
REFETCH CursorName INTO {: HostVariable [[ INDICATOR] : Indicator ]}[,...]
RELEASE
RELEASE
REMOVE DBEFILE
REMOVE DBEFILE DBEFileName FROM DBEFILESET DBEFileSetName
REMOVE FROM GROUP
REMOVE { DBEuserID
GroupName
ClassName }[,...]FROM GROUP [ Owner. ] TargetGroupName
RENAME COLUMN
RENAME COLUMN [ Owner. ] TableName.ColumnName TO NewColumnName
RENAME TABLE
RENAME TABLE [ Owner. ] TableName TO NewTableName
RESET
RESET {SYSTEM.ACCOUNT [FOR USER {*
DBEUserID }]
SYSTEM.COUNTER }