SQL$HELP_OLD72.HLB  —  DECLARE  MODULE  Format
  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 -+      |
   +--------------------------- <-----------------------+
Close Help