Syntax

Click to skip syntax diagram
Read syntax diagramSkip visual syntax diagram>>-EXECUTE--statement-name-------------------------------------->
 
>--+-----------------------------------+-----------------------><
   |        .-,--------.               |
   |        V          |               |
   +-USING----variable-+---------------+
   +-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.