6.6.1 Rules for specifying dynamic parameters

1. The data type and data length that are assumed by a specified dynamic parameter differ depending on the location in which the parameter is specified. The following table describes the data type and data length that are assumed by dynamic parameters.

   Table 6‒12: Assumed data type and data length of dynamic parameters

   No.	Where the dynamic parameter is specified	Assumed data type and data length
   1	Specified alone in a predicate (other than LIKE, NULL, and LIKE_REGEX predicates)	Data type and data length of the result of the value expression it is compared against
   2	Specified alone as the insertion value specified in a VALUES clause in an INSERT statement Specified alone as the update value specified in a SET clause in an UPDATE statement	Data type and data length of the column being assigned
   3	Specified elsewhere	Refer to the description of each item.

2. A maximum of 1,000 dynamic parameters can be specified in an SQL statement.

3. When you pass a value to a dynamic parameter, pass a value of the assumed data type and data length.

4. Make sure that the total data length of dynamic parameters specified in an SQL statement does not exceed 32,000,000 bytes.

To Page Top