Syntax

Click to skip syntax diagram
Read syntax diagramSkip visual syntax diagram>>-CALL--+-procedure-name-+------------------------------------->
         '-variable-------'
 
>--+----------------------------------------------------------+-><
   +-(--+------------------------------------------------+--)-+
   |    | .-,------------------------------------------. |    |
   |    | V                                            | |    |
   |    '---+-variable-------------------------------+-+-'    |
   |        +-constant-------------------------------+        |
   |        +-NULL-----------------------------------+        |
   |        +-special-register-----------------------+        |
   |        +-DLVALUE--(--arguments--)---------------+        |
   |        '-cast-function-name--(--+-variable-+--)-'        |
   |                                 '-constant-'             |
   +-SQL-descriptors------------------------------------------+
   '-USING DESCRIPTOR--descriptor-name------------------------'
 
SQL-descriptors:
 
|--+------------------------------------------------------------+-->
   |       .-SQL-.              .-LOCAL--.                      |
   '-INTO--+-----+--DESCRIPTOR--+--------+--SQL-descriptor-name-'
                                '-GLOBAL-'
 
>--+------------------------------------------------------------------+--|
   |              (1)                                                 |
   |        .-SQL------.              .-LOCAL--.                      |
   '-USING--+----------+--DESCRIPTOR--+--------+--SQL-descriptor-name-'
                                      '-GLOBAL-'
 
Notes:
  1. If an SQL descriptor is specified in the USING clause and the INTO clause is not specified, USING DESCRIPTOR is not allowed and USING SQL DESCRIPTOR must be specified.