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