DECLARE MODULE <module-name> --+------------------------+-+
+-> DIALECT environment -+ |
+---------------------------------------------------------+
+-+---------------------+-+-----------------------------+-+
+-> char-set-options -+ +---> CATALOG <catalog-name> -+ |
+---------------------------------------------------------+
+-+------------------------++----------------------------++
+-> SCHEMA <schema-name> ++-> AUTHORIZATION <auth-id> -+|
+---------------------------------------------------------+
+-+--------------------------------+-+----------------------------+--->
+-> PRAGMA (module-pragma-list) -+ +-> module-language-options -+
environment =
--+--> SQL99 -----+->
+--> SQL92 -----+
+--> SQL89 -----+
+--> SQLV40 ----+
+--> MIA -------+
char-set-options =
--+----------------> -------------+-----+
+--> NAMES ARE names-char-set --+ |
+----------------- <--------------------+
++-+---------------> ------------------------------+-+->
| +--> LITERAL CHARACTER SET support-char-set ----+ |
| +--> NATIONAL CHARACTER SET support-char-set ---+ |
| +--> DEFAULT CHARACTER SET support-char-set ----+ |
| +--> IDENTIFIER CHARACTER SET names-char-set ---+ |
| +--> DISPLAY CHARACTER SET names-char-set ------+ |
+---------------------------<-----------------------+
module-pragma-list =
-----------------> IDENT string-literal ----------->
module-language-options =
-+-+---> ALIAS <alias-name> ------------------------+-+-->
| +---> CHARACTER LENGTH -+-> CHARACTERS -+--------+ |
| | +-> OCTETS -----+ | |
| +---> DEFAULT DATE FORMAT --+--> SQL99 -+--------+ |
| | +--> SQL92 -+ | |
| | +--> VMS ---+ | |
| +---> KEYWORD RULES environment -----------------+ |
| +---> PARAMETER COLONS --------------------------+ |
| +---> QUOTING RULES environment -----------------+ |
| +---> RIGHTS --+--> INVOKER ---+-----------------+ |
| | +--> RESTRICT --+ | |
| +---> VIEW UPDATE RULES environment -------------+ |
| +---> QUIET COMMIT -+-> ON ---+------------------+ |
| | +-> OFF --+ | |
| +---> COMPOUND TRANSACTIONS -+-> INTERNAL -+----+ |
| +-> EXTERNAL -+ |
+--------------------------- <-----------------------+