- 论坛徽章:
- 0
|
如何为DB2/400创建存储过程?
1. RunSqlStm
编辑文本文件,使用标准sql语句
2. 使用query manager
+--------------------------------------------------------------------------------------------------+
| |
| |
| |
| >;>;--CREATE--PROCEDURE--procedure-name---------------------------------------------------------->; |
| |
| >;---------------------------------------------------------------------------------------------->; |
| +-(--------------------------------------------------------)-+ |
| | <-,--------------------------------------------+ | |
| | +-IN----+ | | |
| +-----+-------+----------------------data-type-----+ |
| |-OUT---| +-parameter-name-+ |
| +-INOUT-+ |
| |
| >;---------------------------------procedure-body---------------------------------------------->;< |
| +-RESULT----SET-----integer-+ |
| +-SETS-+ |
| |
| procedure-body: |
| +-EXTERNAL-----------------------------+ |
| |--+--------------------------------------+---------------------------------------------------->; |
| +-EXTERNAL NAME--external-program-name-+ |
| |
| +-PARAMETER STYLE-+ (1) +-VARIANT-----+ |
| >;----------------------------------------------------GENERAL---------------+-------------+-----| |
| +-LANGUAGE----C---------+ +-GENERAL WITH NULLS-+ +-NOT VARIANT-+ |
| |-CL------| |
| |-COBOL---| |
| |-COBOLLE-| |
| |-FORTRAN-| |
| |-PLI-----| |
| |-REXX----| |
| |-RPG-----| |
| +-RPGLE---+ |
| |
| data-type: |
| |------INTEGER---------------------------------------------------------------------------------| |
| | +-INT-----+ | |
| |---SMALLINT------------------------------------------------------------| |
| |---FLOAT---------------------------------------------------------------| |
| | | +-(--integer--)-+ | | |
| | |-REAL---------------------| | |
| | | +-PRECISION-+ | | |
| | +-DOUBLE-------------------+ | |
| |---DECIMAL-------------------------------------------------------------| |
| | |-DEC-----| +-(--integer-----------------)-+ | |
| | +-NUMERIC-+ +-, integer-+ | |
| |-----CHARACTER---------------------------------------------------------| |
| | | +-CHAR------+ +-(--integer--)-+ | |-FOR BIT DATA---| | |
| | +-----VARCHAR-------------------(--integer--)---+ |-FOR SBCS DATA--| | |
| | +---CHARACTER----VARYING-+ |-FOR MIXED DATA-| | |
| | +-CHAR------+ +-CCSID--integer-+ | |
| |-----GRAPHIC-----------------------------------------------------------| |
| | | +-(--integer--)-+ | +-CCSID--integer-+ | |
| | +-----VARGRAPHIC---------(--integer--)---+ | |
| | +-GRAPHIC VARYING-+ | |
| |---DATE----------------------------------------------------------------| |
| |---TIME----------------------------------------------------------------| |
| +---TIMESTAMP-----------------------------------------------------------+ |
| |
| Note: |
| |
| (1) The keywords SIMPLE CALL can be used as a synonym for GENERAL. |
| |
| |
| |
| |
+------------------------------------------ |
|