Syntax

Click to skip syntax diagram
Read syntax diagramSkip visual syntax diagram>>-COMMENT--ON-------------------------------------------------->
 
>--+-+-ALIAS--alias-name----------------------------------------------------+--IS--string-constant-+-><
   | +-COLUMN--+-table-name.column-name-+-----------------------------------+                      |
   | |         '-view-name.column-name--'                                   |                      |
   | +-+----------+--TYPE--distinct-type-name-------------------------------+                      |
   | | '-DISTINCT-'                                                         |                      |
   | +-+-+-FUNCTION-+--function-name--+------------------------------+-+----+                      |
   | | | '-ROUTINE--'                 '-(--+--------------------+--)-' |    |                      |
   | | |                                   | .-,--------------. |      |    |                      |
   | | |                                   | V                | |      |    |                      |
   | | |                                   '---parameter-type-+-'      |    |                      |
   | | '-SPECIFIC--+-FUNCTION-+--specific-name-------------------------'    |                      |
   | |             '-ROUTINE--'                                             |                      |
   | +-INDEX--index-name----------------------------------------------------+                      |
   | +-PACKAGE--package-name--+-------------------------+-------------------+                      |
   | |                        | .-VERSION-.             |                   |                      |
   | |                        '-+---------+--version-id-'                   |                      |
   | +-PARAMETER--+-routine-name.parameter-name---------------------------+-+                      |
   | |            '-SPECIFIC--+-FUNCTION--+--specific-name.parameter-name-' |                      |
   | |                        +-PROCEDURE-+                                 |                      |
   | |                        '-ROUTINE---'                                 |                      |
   | +-+-+-PROCEDURE-+--procedure-name--+------------------------------+-+--+                      |
   | | | '-ROUTINE---'                  '-(--+--------------------+--)-' |  |                      |
   | | |                                     | .-,--------------. |      |  |                      |
   | | |                                     | V                | |      |  |                      |
   | | |                                     '---parameter-type-+-'      |  |                      |
   | | '-SPECIFIC--+-PROCEDURE-+--specific-name--------------------------'  |                      |
   | |             '-ROUTINE---'                                            |                      |
   | +-SEQUENCE--sequence-name----------------------------------------------+                      |
   | +-TABLE--+-table-name-+------------------------------------------------+                      |
   | |        '-view-name--'                                                |                      |
   | '-TRIGGER--trigger-name------------------------------------------------'                      |
   +-multiple-column-list--------------------------------------------------------------------------+
   '-multiple-parameter-list-----------------------------------------------------------------------'
 
Read syntax diagramSkip visual syntax diagrammultiple-column-list:
 
                                  .-,--------------------------------.
   .-COLUMN-.                     V                                  |
|--+--------+--+-table-name-+--(----column-name--IS--string-constant-+--)--|
               '-view-name--'
 
multiple-parameter-list:
 
|--PARAMETER--+-SPECIFIC--+-FUNCTION--+--specific-name------------------------+-->
              |           +-PROCEDURE-+                                       |
              |           '-ROUTINE---'                                       |
              | .-ROUTINE---.                                                 |
              '-+-----------+--routine-name--+------------------------------+-'
                +-FUNCTION--+                '-(--+--------------------+--)-'
                '-PROCEDURE-'                     | .-,--------------. |
                                                  | V                | |
                                                  '---parameter-type-+-'
 
      .-,-----------------------------------.
      V                                     |
>--(----parameter-name--IS--string-constant-+--)----------------|
 
parameter-type:
 
|----data-type--+------------+----------------------------------|
                '-AS LOCATOR-'
 
data-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-------------------------------------------------------------------------------------------------------'