Specification of Db2 for z/OS bind options from IBM Data Server clients and drivers

When you bind packages on Db2 for z/OS data servers from IBM® Data Server clients and drivers, you need to specify bind options that are supported by Db2 for z/OS but not by Db2 for Linux®, UNIX, and Windows as generic bind options.

You can use the following IBM Data Server client and driver interfaces to specify Db2 for z/OS-only bind options:

For Java™ clients, when you use IBM Data Server Driver for JDBC and SQLJ utility DB2Binder or method DB2Binder.runJDBCBinder to bind IBM Data Server Driver for JDBC and SQLJ packages or rebind user packages, specify the Db2 for z/OS bind options as sub-options of the -bindOptions parameter. For example:
```
java com.ibm.db2.jcc.DB2Binder -url jdbc:db2://srv1.svl.ibm.com:446/DB1 
-user myid -password mypass -action replace 
-bindOptions "IMMEDWRITE YES"  
```

For non-Java clients, when you use CLI method SQLCreatePkg to bind packages, specify the Db2 for z/OS bind options as sub-options of the GENERIC option in the szBindOpts string. For example:

strcpy (bindFileName, "/u/user1/sqllib/bnd/@all.lst");
cliRC = SQLCreatePkg(hdbc,
                     bindFileName,
                     strlen(bindFileName),
                     "GENERIC=IMMEDWRITE NO"
                     -3, // SQL_NTS);

You can specify the following Db2 for z/OS bind options as generic bind options:

APCOMPARE
APRETAINDUP
APREUSE
APPLCOMPAT
ARCHIVESENSITIVE
BUSTIMESENSITIVE
CONCURRENTACCESSRESOLUTION
DBPROTOCOL
DEFER(PREPARE) or NODEFER(PREPARE)
EXPLAIN
EXTENDEDINDICATOR
IMMEDWRITE
OPTHINT
PATHDEFAULT (rebind only)
PLANMGMT (rebind only)
REOPT
ROUNDING
SWITCH (rebind only)
SYSTIMESENSITIVE