Syntax

Click to skip syntax diagram
Read syntax diagramSkip visual syntax diagram>>-PREPARE--statement-name-------------------------------------->
 
>--+-----------------------------------------------------------------+-->
   |          .-SQL-.              .-LOCAL--.                        |
   '-+-USING--+-----+--DESCRIPTOR--+--------+--SQL-descriptor-name-+-'
     |                             '-GLOBAL-'                      |
     '-INTO----descriptor-name----+-------------------------+------'
                                  '-USING--+-NAMES--------+-'
                                           +-SYSTEM NAMES-+
                                           +-LABELS-------+
                                           +-ANY----------+
                                           +-BOTH---------+
                                           '-ALL----------'
 
>--+-FROM--string-expression-----------------------+-----------><
   '-+---------------------------+--FROM--variable-'
     '-ATTRIBUTES--attr-variable-'
 
Read syntax diagramSkip visual syntax diagramattribute-string:
 
   .------------------------------------.
   V                                    | (1)
|----+--------------------------------+-+-----------------------|
     +-+-ASENSITIVE-------------+-----+
     | +-INSENSITIVE------------+     |
     | |            .-DYNAMIC-. |     |
     | '-SENSITIVE--+---------+-'     |
     +-+-NO SCROLL-+------------------+
     | '-SCROLL----'                  |
     +-+-WITHOUT HOLD-+---------------+
     | '-WITH HOLD----'               |
     +-+-WITHOUT RETURN-------------+-+
     | |              .-TO CALLER-. | |
     | '-WITH RETURN--+-----------+-' |
     |                '-TO CLIENT-'   |
     +-fetch-first-clause-------------+
     +-+-read-only-clause-+-----------+
     | '-update-clause----'           |
     +-optimize-clause----------------+
     '-isolation-clause---------------'
 
Notes:
  1. The same clause must not be specified more than once. If the options are not specified, their defaults are whatever was specified for the corresponding options in an associated DECLARE CURSOR and the prepared SELECT statement.