>>-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-----------------------------------------------------------------------'
multiple-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-'
built-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-------------------------------------------------------------------------------------------------------'
(C) Copyright IBM Corporation 1992, 2006. All Rights Reserved.