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 -+ | +--------------------------- <-----------------------+