db2存储过程基本语法（DB2 stored procedure basic syntax）.doc

db2存储过程基本语法（DB2 stored procedure basic syntax） Syntax description 1. The name of the procedure-name: stored procedure. In the same schema of the same database, there is no stored procedure with the same number of parameters as the stored procedure name, even if the parameter type is different. Leizhimin 51CTO technology blog 2, (IN OUT INOUT parameter-name data-type | |,...): incoming parameters IN: input parameter OUT: output parameter INOUT: as input and output parameters Parameter-name: parameter names, unique identifiers in this stored procedure. The data-type: parameter type can accept the SQL type and create the table. LONG, VARCHAR, LONG, VARGRAPHIC, DATALINK, REFERENCE, and user-defined types are not supported. 3, SPECIFIC, specific-name: the only specific name (Bie Ming) that can be replaced by the stored procedure name, which is used for the dorp stored procedure, or is added to the stored procedure Use, but cannot call stored procedures. If not specified, the database automatically generates a yymmddhhmmsshhn timestamp name. Alias is recommended. 4, DYNAMIC, RESULT, SETS, integer: Specifies the maximum number of results returned by stored procedures. Stored procedures do not have return statements, but they can return the result set. 5, CONTAINS, SQL, READS, SQL, DATA, MODIFIES, SQL, DATA: specify the SQL access level in the stored procedure CONTAINS SQL: indicates that the stored procedure can be executed, neither SQL data nor SQL data can be read. READS SQL DATA: indicates that stored procedures can be executed and SQL can be read, but SQL data cannot be modified. MODIFIES SQL DATA: indicates that stored procedures can execute any SQL statement. The data in the database can be added, deleted and modified. 6, DETERMINISTIC, or, NOT, DETERMINISTIC: indicates that stored procedures are dynamic or non dynamic. The value of the dynamic return is uncertain. A non dynamic stored procedure that returns every time it is executed The values are the same. 7, CALLE