ALLBASE/SQL Reference Manual (36216-90216)

Appendix A 607
SQL Syntax Summary
Non-BULK HostVariableSpecification
{: HostVariable [[INDICATOR]: Indicator ] } [,...]
GENPLAN
GENPLAN [WITH ( HostVariableDefinition )] FOR
{ SQLStatement
MODULE SECTION [ Owner. ] ModuleName(Section Number )
PROCEDURE SECTION [ Owner. ] ProcedureName(Section Number )}
GOTO
{GOTO
GO TO}{ Label
Integer }
GRANT
GRANT {ALL [PRIVILEGES]
{SELECT
INSERT
DELETE
ALTER
INDEX
UPDATE [({ ColumnName }[,...])]
REFERENCES [({ ColumnName }[,...])]}|,...|}
ON {[ Owner. ] TableName
[ Owner. ] ViewName }TO { DBEUserID
GroupName
ClassName
PUBLIC } [,...][WITH GRANT OPTION]
[BY { DBEUserID
ClassName }]
Grant RUN or EXECUTE Authority
GRANT {RUN ON [ Owner .] ModuleName
EXECUTE ON PROCEDURE [ Owner. ] ProcedureName }TO
{{ DBEUserID
GroupName
ClassName } [,...]
PUBLIC }
Grant CONNECT, DBA, INSTALL, MONITOR, or RESOURCE Authority
GRANT {CONNECT
DBA
INSTALL [AS OwnerID ]
MONITOR
RESOURCE } TO { DBEUserID
GroupName
ClassName } [,...]