ALLBASE/SQL Reference Manual (36216-90216)

340 Chapter10
SQL Statements A - D
CREATE PROCEDURE
• IF...THEN...ELSEIF...ELSE...ENDIF
• WHILE...DO...ENDWHILE
• Jump statement (GOTO, GO TO, or RETURN)
• PRINT
• Any SQL statement allowed in an application
except the following:
ADVANCE
BEGIN DECLARE SECTION
BULK statements
CLOSE (when the USING clause is specified)
COMMIT WORK RELEASE
CONNECT
CREATE PROCEDURE (including inside CREATE SCHEMA)
DECLARE CURSOR (when declaring a cursor for an EXECUTE
PROCEDURE statement)
DESCRIBE
DISCONNECT
END DECLARE SECTION
EXECUTE
EXECUTE IMMEDIATE
EXECUTE PROCEDURE
GENPLAN
INCLUDE
OPEN CURSOR USING DESCRIPTOR
OPEN CURSOR USING HostVariableList
PREPARE
RELEASE
ROLLBACK WORK RELEASE
SET CONNECTION
SET DML ATOMICITY
SET MULTITRANSACTION
SET SESSION
SET TRANSACTION
SQLEXPLAIN
START DBE
STOP DBE
A ProcedureStatement must be terminated by a semicolon.
DBEFileSetName identifies the DBEFileSet in which ALLBASE/SQL is to store sections
associated with the procedure. If not specified, the SECTIONSPACE
DBEFileSet is used.
SQL Syntax—ParameterDeclaration
ParameterName ParameterType [LANG = ParameterLanguage ]
[DEFAULT DefaultValue ][NOT NULL][OUTPUT [ONLY]]