DB2 Stored Procedure attribute description, db2 stored procedure description

DB2 Stored Procedure attribute description, db2 stored procedure description

ProcedureName: name of the stored procedure. It cannot exist in the same database mode.

Stored Procedure with the same name and number of parameters, even if the parameter type is different

(In | out | inout paramName dataType ,...) : Input parameters

In: input parameter, out: output parameter, inout: As input and output parameter

DataType: parameter type. It can receive SQL statements and tables created. long varchar is not supported,

Long vargraphic, datalink, reference, and user-defined types.

Specific specificName: a unique name (alias) that can be replaced by a stored procedure name.

It is used to add comments to stored procedures, but cannot call stored procedures. If not specified, the database

A timestamp name of yymmddhhmmsshhn is automatically generated.

Language SQL: the subject of the specified process uses the SQL language.

Dynamic result sets integer: specifies the maximum number of results returned by a stored procedure. If the returned result is smaller than the actual number, db2 returns a warning.

Deterministic or not deterministic: indicates whether the stored procedure is dynamic or non-dynamic.

Dynamic return values are uncertain, and non-dynamic return values are the same each time.

External action or no external action: indicates whether the Stored Procedure changes the database status,

Instead of using the database manager. The default value is external action. If no external action is specified,

The database determines the Best optimization solution.

Contains SQL, reads SQL data, modifies SQL data: Specifies the SQL access level in the Stored Procedure

Contains SQL: indicates that the stored procedure can be executed. Neither SQL data can be read nor SQL data can be modified.

Reads SQL data: indicates that the stored procedure can be executed and can read but cannot modify SQL data.

Modifies SQL data: indicates that the stored procedure can execute any SQL statement. You can perform

Add, delete, and modify.

Old savepoint level or new savepoint level: Creates a storage point to store data at a certain time ),

The old savepoint level is the default storage point.

Called on null input: indicates that a stored procedure can be called, regardless of whether any input parameter is NULL,

Any out or inout parameter can return a NULL or non-NULL value. Check whether the parameter is NULL.

Inherit special registers: Indicates inheriting the dedicated register

Parameter ccsid: Specifies the encoding of all output string data. The default unicode encoding database is parameter ccsid unicode,

The default value of other databases is parameter ccsid 3 ascii.