GENERIC bind option
The GENERIC option specifies one or more bind options that are supported by the target server, but are not supported as options for BIND PACKAGE or REBIND PACKAGE on the Db2 for z/OS® subsystem on which the BIND or REBIND command is issued.
| Command option | Option values | Used with |
|---|---|---|
| GENERIC | ( 'string' ) |
- The GENERIC bind option is not valid for REBIND of packages for native SQL procedures, native REST services, or advanced triggers..
Do not use GENERIC to specify any of the following options:
- Bind options that are explicitly supported by Db2 for z/OS for BIND PACKAGE or REBIND PACKAGE
- SQL processing options that are explicitly supported by Db2 for z/OS
- GENERIC('string')
- One or more pairs of a bind option and its corresponding value. Separate each item by one or more blank spaces.
The maximum length of the string is 4096 bytes. Within that string, each individual option name cannot exceed 255 characters, and each individual option value cannot exceed 255 characters.
Example for GENERIC
For example, the following GENERIC option specifies several bind options and their corresponding values:
GENERIC( ' option-1 value-1 option-2 value-2..... option-n value-n ' )In this example, value-1 is specified for bind option option-1, value-2 is specified for bind option option-2, and so on.
If you specify a bind option more than once in the GENERIC string, only the first occurrence is used. All subsequent occurrences of the bind option and its corresponding value are ignored. For example, suppose that you specify the following GENERIC option:
GENERIC( ' firstoption firstvalue secondoption secondvalue firstoption thirdvalue' )In this example, firstoption and secondoption are bind options that are sent to the target server with their corresponding values. The third option and value pair (firstoption thirdvalue) is ignored, because firstoption is already specified in the string. This pair is not sent to the target server.