Syntax

Click to skip syntax diagram

 

Read syntax diagramSkip visual syntax diagram                 .-PRIVILEGES-.
>>-GRANT--+-ALL--+------------+-+--ON--------------------------->
          | .-,-----------.     |
          | V             |     |
          '---+-ALTER---+-+-----'
              '-EXECUTE-'
 
   .-,-----------------------------------------------------------------------.
   V                                                                         |
>----+-+-+-FUNCTION-+--function-name--+------------------------------+-+---+-+-->
     | | '-ROUTINE--'                 '-(--+--------------------+--)-' |   |
     | |                                   | .-,--------------. |      |   |
     | |                                   | V                | |      |   |
     | |                                   '---parameter-type-+-'      |   |
     | '-SPECIFIC--+-FUNCTION-+--specific-name-------------------------'   |
     |             '-ROUTINE--'                                            |
     '-+-+-PROCEDURE-+--procedure-name--+------------------------------+-+-'
       | '-ROUTINE---'                  '-(--+--------------------+--)-' |
       |                                     | .-,--------------. |      |
       |                                     | V                | |      |
       |                                     '---parameter-type-+-'      |
       '-SPECIFIC--+-PROCEDURE-+--specific-name--------------------------'
                   '-ROUTINE---'
 
       .-,----------------------.
       V                        |
>--TO----+-authorization-name-+-+--+-------------------+-------><
         '-PUBLIC-------------'    '-WITH GRANT OPTION-'
 
Read syntax diagramSkip visual syntax diagramparameter-type:
 
|----data-type--+------------+----------------------------------|
                '-AS LOCATOR-'
 
Read syntax diagramSkip visual syntax diagramdata-type:
 
|--+-built-in-type------+---------------------------------------|
   '-distinct-type-name-'
 
Read syntax diagramSkip visual syntax diagrambuilt-in-type:
 
|--+-+---SMALLINT---+----------------------------------------------------------------------------------------------+--|
   | +-+-INTEGER-+--+                                                                                              |
   | | '-INT-----'  |                                                                                              |
   | '---BIGINT-----'                                                                                              |
   |                  .-(5,0)----------------------------.                                                         |
   +-+-+-DECIMAL-+-+--+----------------------------------+---------------------------------------------------------+
   | | '-DEC-----' |  '-(--+------------------------+--)-'                                                         |
   | '-NUMERIC-----'       '-integer--+-----------+-'                                                              |
   |                                  '-, integer-'                                                                |
   |          .-(53)----------.                                                                                    |
   +-+-FLOAT--+---------------+-+----------------------------------------------------------------------------------+
   | |        '-(--integer--)-' |                                                                                  |
   | +-REAL---------------------+                                                                                  |
   | |         .-PRECISION-.    |                                                                                  |
   | '-DOUBLE--+-----------+----'                                                                                  |
   |                    .-(1)---------------.                                                                      |
   +-+-+-+-CHARACTER-+--+-------------------+--------------+--+----------------+---------------------------------+-+
   | | | '-CHAR------'  '-(--+---------+--)-'              |  +-FOR BIT DATA---+                                 | |
   | | |                     '-integer-'                   |  +-FOR SBCS DATA--+                                 | |
   | | '---+-+-CHARACTER-+--VARYING-+--(--+---------+--)---'  +-FOR MIXED DATA-+                                 | |
   | |     | '-CHAR------'          |     '-integer-'         '-CCSID--integer-'                                 | |
   | |     '-VARCHAR----------------'                                                                            | |
   | |                                          .-(1M)---------------------.                                     | |
   | '-----+-+-CHARACTER-+--LARGE OBJECT-+------+--------------------------+--+----------------+--+------------+-' |
   |       | '-CHAR------'               |      '-(--+---------+--+---+--)-'  +-FOR SBCS DATA--+  '-AS LOCATOR-'   |
   |       '-CLOB------------------------'           '-integer-'  +-K-+       +-FOR MIXED DATA-+                   |
   |                                                              +-M-+       '-CCSID--integer-'                   |
   |                                                              '-G-'                                            |
   |                  .-(1)---------------.                                                                        |
   +-+-+---GRAPHIC----+-------------------+---------+--+----------------+-----------+------------------------------+
   | | |              '-(--+---------+--)-'         |  '-CCSID--integer-'           |                              |
   | | |                   '-integer-'              |                               |                              |
   | | '---+-VARGRAPHIC------+--(--+---------+--)---'                               |                              |
   | |     '-GRAPHIC VARYING-'     '-integer-'                                      |                              |
   | |             .-(1M)---------------------.                                     |                              |
   | '---DBCLOB----+--------------------------+--+----------------+--+------------+-'                              |
   |               '-(--+---------+--+---+--)-'  '-CCSID--integer-'  '-AS LOCATOR-'                                |
   |                    '-integer-'  +-K-+                                                                         |
   |                                 +-M-+                                                                         |
   |                                 '-G-'                                                                         |
   |             .-(1)---------------.                                                                             |
   +-+-+-BINARY--+-------------------+---------+---------------------------------+---------------------------------+
   | | |         '-(--+---------+--)-'         |                                 |                                 |
   | | |              '-integer-'              |                                 |                                 |
   | | '-+-BINARY VARYING-+--(--+---------+--)-'                                 |                                 |
   | |   '-VARBINARY------'     '-integer-'                                      |                                 |
   | |                              .-(1M)---------------------.                 |                                 |
   | '---+-BLOB----------------+----+--------------------------+--+------------+-'                                 |
   |     '-BINARY LARGE OBJECT-'    '-(--+---------+--+---+--)-'  '-AS LOCATOR-'                                   |
   |                                     '-integer-'  +-K-+                                                        |
   |                                                  +-M-+                                                        |
   |                                                  '-G-'                                                        |
   +-+---DATE-----------------+------------------------------------------------------------------------------------+
   | |       .-(--0--)-.      |                                                                                    |
   | +-TIME--+---------+------+                                                                                    |
   | |            .-(--6--)-. |                                                                                    |
   | '-TIMESTAMP--+---------+-'                                                                                    |
   |             .-(200)-------------.                                                                             |
   +---DATALINK--+-------------------+--+----------------+---------------------------------------------------------+
   |             '-(--+---------+--)-'  '-CCSID--integer-'                                                         |
   |                  '-integer-'                                                                                  |
   '---ROWID-------------------------------------------------------------------------------------------------------'