Parameter style GENERAL

Edit online

With the GENERAL parameter style, the parameters are passed to an external program just as they are specified in the CREATE PROCEDURE statement.

The format is:

Read syntax diagramSkip visual syntax diagramSQL-parameter
SQL-parameter
This argument is set by Db2® before calling the procedure. This value repeats n times, where n is the number of parameters specified in the procedure call. The value of each of these parameters is taken from the expression specified in the CALL statement. It is expressed in the data type of the defined parameter in the CREATE PROCEDURE statement. Note: Changes to any parameters that are defined as INPUT will be ignored by Db2 upon return.