SQL$HELP_OLD72.HLB  —  DECLARE  Routine  Format
  DECLARE --+-> FUNCTION ---+-> <routine-name> ------------------+
            +-> PROCEDURE --+                                    |
    +----------------------------- <-----------------------------+
    +-+--------------------------------+-------------------------+
      +-> STORED NAME IS <identifier> -+                         |
    +--------------------------- <-------------------------------+
    +-> ( -+-----------------------+-> ) ------------------------+
           ++-> parameter-list --+-+                             |
            +-------- , <--------+                               |
    +--------------------------- <-------------------------------+
    +-+-------------------+--> --+------------------+---------------->
      +-> returns-clause -+      +-> LANGUAGE SQL --+

  parameter-list =

  -+----------+-+-------------------+-+-> data-type -----+----------+
   +-> IN ----+ +> <parameter-name> + +-> <domain-name> -+          |
   +-> OUT ---+                                                     |
   +-> INOUT -+                                                     |
  +-----------------------------------------------------------------+
  +-+---------------------------+--+---------------------+----------+
    +-> DEFAULT value-expr -----+  +-> mechanism-clause -+          |
   +------------------------------<---------------------------------+
   ++---------------------------------+------------------------------->
    +-> COMMENT IS -+-> 'string' ---+-+
                    +------ / <-----+

  mechanism-clause =

  ----> BY --+-> DESCRIPTOR -+--->
             +-> LENGTH -----+
             +-> REFERENCE --+
             +-> VALUE ------+

  returns-clause =

   ---> RETURNS -+> result-data-type -++---------------------+-->
                 +> <domain-name> ----++-> mechanism-clause -+
Close Help