Skip to content
Reference>Meta Database>Scripting Reference

Scripting Reference

Currently supported scripting language elements are:

sql
-- Variable / Resultset / Exception Declaration 
[DECLARE] 

BEGIN 

-- Branching
  [IF ... ]   
  [CASE ... ]

-- Loops
  [FOR ... ]
  [WHILE ... ]
    -- Loop control 
    [BREAK] 
    [CONTINUE]

-- Variable Assignment
  [LET ...]

-- "No-op" Statement
  [NULL]

-- Exceptions
  [RAISE ...]

-- Return Values
  [RETURN ...]

-- Exception Handling
[EXCEPTION ...]

END;

BEGIN ... END
BREAK (EXIT)
CASE
CONTINUE (ITERATE)
DECLARE
EXCEPTION
FOR
IF
LET
NULL
RAISE
RETURN
WHILE