Syntax

Click to skip syntax diagram
Read syntax diagramSkip visual syntax diagram>>-ALTER-------------------------------------------------------->
 
>--+-PROCEDURE--procedure-name--+------------------------------+-+-->
   |                            |    .-,------------------.    | |
   |                            |    V                    |    | |
   |                            '-(----+----------------+-+--)-' |
   |                                   '-parameter-type-'        |
   |                                                             |
   |                                                             |
   '-SPECIFIC PROCEDURE--specific-name---------------------------'
 
   .-ALTER-.
>--+-------+--option-list--------------------------------------><
 
parameter-type:
 
|----data-type--+------------+----------------------------------|
                '-AS LOCATOR-'
 
data-type:
 
|--+-built-in-type------+---------------------------------------|
   '-distinct-type-name-'
 
Read syntax diagramSkip visual syntax diagramoption-list:
 
|--+-----------------------+------------------------------------>
   '-LANGUAGE--+-C-------+-'
               +-C++-----+
               +-CL------+
               +-COBOL---+
               +-COBOLLE-+
               +-FORTRAN-+
               +-JAVA----+
               +-PLI-----+
               +-REXX----+
               +-RPG-----+
               '-RPGLE---'
 
>--+----------------------------------------+------------------->
   '-+-PARAMETER STYLE SQL----------------+-'
     +-PARAMETER STYLE DB2SQL-------------+
     +-PARAMETER STYLE GENERAL------------+
     +-PARAMETER STYLE GENERAL WITH NULLS-+
     +-PARAMETER STYLE JAVA---------------+
     '-PARAMETER STYLE DB2GENERAL---------'
 
                         (1)
>--+-------------------+-------+-------------------+------------>
   +-NOT DETERMINISTIC-+       +-MODIFIES SQL DATA-+
   '-DETERMINISTIC-----'       +-READS SQL DATA----+
                               +-CONTAINS SQL------+
                               '-NO SQL------------'
 
   .-CALLED ON NULL INPUT-.  .-INHERIT SPECIAL REGISTERS-.
>--+----------------------+--+---------------------------+------>
 
>--+------------------------------+--+-----------+-------------->
   '-DYNAMIC RESULT SETS--integer-'  +-NO DBINFO-+
                                     '-DBINFO----'
 
>--+---------------------+--+------------+---------------------->
   +-ALLOW DEBUG MODE----+  +-FENCED-----+
   +-DISABLE DEBUG MODE--+  '-NOT FENCED-'
   '-DISALLOW DEBUG MODE-'
 
>--+--------------------------------------+--------------------->
   '-EXTERNAL NAME--external-program-name-'
 
>--+---------------------+--+----------------------+------------|
   +-OLD SAVEPOINT LEVEL-+  +-COMMIT ON RETURN NO--+
   '-NEW SAVEPOINT LEVEL-'  '-COMMIT ON RETURN YES-'
 
Notes:
  1. The clauses in the option-list can be specified in any order.
Read syntax diagramSkip visual syntax diagrambuilt-in-type:
 
|--+-+---SMALLINT---+--------------------------------------------------------------------------+--|
   | +-+-INTEGER-+--+                                                                          |
   | | '-INT-----'  |                                                                          |
   | '---BIGINT-----'                                                                          |
   |                  .-(5,0)------------------------.                                         |
   +-+-+-DECIMAL-+-+--+------------------------------+-----------------------------------------+
   | | '-DEC-----' |  |             .-,0--------.    |                                         |
   | '-NUMERIC-----'  '-(--integer--+-----------+--)-'                                         |
   |                                '-, integer-'                                              |
   |          .-(--53--)------.                                                                |
   +-+-FLOAT--+---------------+-+--------------------------------------------------------------+
   | |        '-(--integer--)-' |                                                              |
   | +-REAL---------------------+                                                              |
   | |         .-PRECISION-.    |                                                              |
   | '-DOUBLE--+-----------+----'                                                              |
   |                    .-(--1--)-------.                                                      |
   +-+-+-+-CHARACTER-+--+---------------+----------+--+----------------+---------------------+-+
   | | | '-CHAR------'  '-(--integer--)-'          |  +-FOR BIT DATA---+                     | |
   | | '-+-+-CHARACTER-+--VARYING-+--(--integer--)-'  +-FOR SBCS DATA--+                     | |
   | |   | '-CHAR------'          |                   +-FOR MIXED DATA-+                     | |
   | |   '-VARCHAR----------------'                   '-ccsid-clause---'                     | |
   | |                                          .-(--1M--)-------------.                     | |
   | '-----+-+-CHARACTER-+--LARGE OBJECT-+------+----------------------+--+----------------+-' |
   |       | '-CHAR------'               |      '-(--integer--+---+--)-'  +-FOR SBCS DATA--+   |
   |       '-CLOB------------------------'                    +-K-+       +-FOR MIXED DATA-+   |
   |                                                          +-M-+       '-ccsid-clause---'   |
   |                                                          '-G-'                            |
   |                .-(--1--)-------.                                                          |
   +-+---GRAPHIC----+---------------+-------+--+--------------+--------------------------------+
   | |              '-(--integer--)-'       |  '-ccsid-clause-'                                |
   | +-+-GRAPHIC VARYING-+--(--integer--)---+                                                  |
   | | '-VARGRAPHIC------'                  |                                                  |
   | |             .-(--1M--)-------------. |                                                  |
   | '---DBCLOB----+----------------------+-'                                                  |
   |               '-(--integer--+---+--)-'                                                    |
   |                             +-K-+                                                         |
   |                             +-M-+                                                         |
   |                             '-G-'                                                         |
   |             .-(--1--)-------.                                                             |
   +-+-+-BINARY--+---------------+---------+-----------------+---------------------------------+
   | | |         '-(--integer--)-'         |                 |                                 |
   | | '-+-BINARY VARYING-+--(--integer--)-'                 |                                 |
   | |   '-VARBINARY------'                                  |                                 |
   | |                              .-(--1M--)-------------. |                                 |
   | '---+-BLOB----------------+----+----------------------+-'                                 |
   |     '-BINARY LARGE OBJECT-'    '-(--integer--+---+--)-'                                   |
   |                                              +-K-+                                        |
   |                                              +-M-+                                        |
   |                                              '-G-'                                        |
   +-+-DATE-------------------+----------------------------------------------------------------+
   | |       .-(--0--)-.      |                                                                |
   | +-TIME--+---------+------+                                                                |
   | |            .-(--6--)-. |                                                                |
   | '-TIMESTAMP--+---------+-'                                                                |
   |             .-(--200--)-----.                                                             |
   +---DATALINK--+---------------+--+--------------+-------------------------------------------+
   |             '-(--integer--)-'  '-ccsid-clause-'                                           |
   '---ROWID-----------------------------------------------------------------------------------'
 
ccsid-clause:
 
                   .-NOT NORMALIZED-.
|--CCSID--integer--+----------------+---------------------------|
                   '-NORMALIZED-----'