This table shows equivalent HCO for DB2 LUW preprocessor -optsql DB2 preprocessor options to the DB2 SQL preprocessor options.
| HCO for DB2 LUW Preprocessor Option | DB2 Preprocessor Option |
|---|---|
| bind | -bind |
| bind=file_name | -bindname file_name |
| block=block_option | -block block_option |
| format=date/time_format | -datetime date/time_format |
| db=name | -dbname name |
| nobind | -nobind |
| isolation=option | -isolation option |
| access=package_name | -package package_name |
To create a package TEST1 using a database named sample and a BIND file test1.bnd would be:
-optsql "db=sample access=test1 bind=test1"