Call	Simple procedure call	CALL <procedure> ([<arguments>]);~n
Call-With-Return	Procedure call with multiple return values	CALL <procedure> ([<arguments>]) RETURNING <var1>,<var2>;~n
Create-Procedure	Name and define a stored procedure	CREATE PROCEDURE <name>~n~t([<param> <datatype>...]) -- parameter(s) declaration}~nRETURNING <datatype>[,<datatype>];~n~t-- enter procedure body here~n~t<statement block>~nEND PROCEDURE;~n~n
Create-Function	Name and define a stored procedure	CREATE FUNCTION <name>~n~t([<param> <datatype>...]) -- parameter(s) declaration}~nRETURNING <datatype>[,<datatype>];~n~t-- enter procedure body here~n~t<statement block>~nEND FUNCTION;~n~n
Create-Trigger	Name and define a trigger on a table in the database	CREATE TRIGGER <name>~n~tINSERT|DELETE|UPDATE OF <column-name>,<column-name> {choose one} ON <table>~n~t[REFERENCING NEW|OLD AS <name>]~n~t[BEFORE]~n~t[WHEN (<sql condition>)]~n~t(<action statement>)~n~t[AFTER]~n~t[WHEN (<sql condition>)]~n~t(<action statement>)~n~t[FOR EACH ROW]~n~t[WHEN (<sql condition>)]~n~t(<action statement>);~n~n
Continue	Proceed to the next iteration of the innermost loop	CONTINUE FOR|WHILE|FOREACH; -- choose one
Define	Declaration of variables that the procedure uses	DEFINE <var1>,<var2> <datatype>;
Exit	Stop the execution of a loop	-- stop the execution of a loop~nEXIT FOR|WHILE|FOREACH; -- choose one
If-Then	Conditional operator	IF <condition> THEN~n~t<statement block>~nEND IF~n
If-Then-Else	Conditional operator with ELSE clause	IF <condition> THEN~n~t<statement block>~nELSE~n~t<statement block>~nEND IF~n
If-Then-Elif	Conditional operator with multiple ELSE clauses	IF <condition> THEN~n~t<statement block>~nELIF <condition>~n~t<statement block>~nELSE~n~t<statement block>~nEND IF~n
For	A definite loop for a range of values	FOR <loop-var> IN (<start> TO <end> [STEP <step>])~n~t<statement block>~nEND FOR~n
ForEach-Select	A loop on a set of rows selected by an SQL query	FOREACH  [<cursor-name> [WITH HOLD] FOR]|[WITH HOLD] <select-into statement>~n~t<statement block>~nEND FOREACH~n
ForEach-Procedure	A loop on a set of rows returned by a procedure	FOREACH EXECUTE PROCEDURE <procedure>(<arguments>) [INTO var[,var]]~n~t<statement block>~nEND FOREACH~n
Let	Assignment to a variable	LET <var> = <expression>;~n
Let	Assignment of a procedure return values to a set of variables	LET <var>,<var> = <procedure>(<arguments>);~n
OnException	Actions to take for a particular error(s)	ON EXCEPTION [IN (<error#>[,<error#>])]~n~t[SET SQLerror-variable,ISAMerror-variable,errordata-variable]~n~t<statement block>~nEND EXCEPTION [WITH RESUME];~n
Raise	Generation of an error	RAISE EXCEPTION <SQL-error#> [, <ISAM-error#> [,<error-text-var>]];~n
Return	Return a value(s) from the procedure	RETURN <expression> [,<expression>];~n
Return-With-Resume	Return the next row of data and resume execution	RETURN <expression> [,<expression>] WITH RESUME;~n-- will continue execution from this point~n
System	Execute operating system command	SYSTEM <expression>;~n
While	Establish an indefinite loop	WHILE <condition>~n~t<statement block>~nEND WHILE~n