ACCESS
Specifies the name of the package to be created and stored in the database. If ACCESS is specified without a parameter, the package name defaults to the program name (without the .CBL extension).
ACTION
Indicates whether the package can be added or replaced.
BIND
Specifies the name of the bind file to be created. When BIND is specified without a parameter, the bind file defaults to the program name with the filename extension replaced by .BND, and is created in the current source directory.
BLOCK
Specifies the record blocking mode to be used on package creation. For information about row blocking, see the IBM DB2 Administration Guide or the Application Programming Guide.
CALL_RESOLUTION
Specifies how a CALL statement will be resolved.
CCSIDG
An integer specifying the coded character set identifier (CCSID) to be used for double byte characters in character column definitions (without a specific CCSID clause) in CREATE and ALTER TABLE SQL statements. This DRDA precompile/bind option is not supported by DB2. The DRDA server will use a system defined default value if this option is not specified.
CCSIDM
An integer specifying the coded character set identifier (CCSID) to be used for mixed byte characters in character column definitions (without a specific CCSID clause) in CREATE and ALTER TABLE SQL statements. This DRDA precompile/bind option is not supported by DB2. The DRDA server will use a system defined default value if this option is not specified.
CCSIDS
An integer specifying the coded character set identifier (CCSID) to be used for single byte characters in character column definitions (without a specific CCSID clause) in CREATE and ALTER TABLE SQL statements. This DRDA precompile/bind option is not supported by DB2. The DRDA server will use a system defined default value if this option is not specified.
CHARSUB
Designates the default character sub-type that is to be used for column definitions in CREATE and ALTER TABLE SQL statements. This DRDA precompile/bind option is not supported by DB2.
COLLECTION
Specifies a 30-character collection identifier for the package. If this is not specified, the authorization identifier for the user processing the package is used.
COMMIT
Specifies where implicit COMMIT statements should be generated.
CONCAT
Specifies the ASCII character code to use for the CONCAT symbol (|).
CONNECT
Specifies that a CONNECT statement is to be processed as either a type 1 CONNECT or a type 2 CONNECT.
COPY
Enables the use SQL host variables in COBOL copybooks.
CTRACE
Creates a trace file for submission to Technical Support if requested. The filename of the file that is created is sqltrace.txt.
DB
Specifies the name of the database that the program accesses. If DB is specified without a parameter, the database specified in the environment variable DB2DBDFT is used.
DEC
Specifies the maximum precision to be used in decimal arithmetic operations. This DRDA precompile/bind option is not supported by DB2. The DRDA server will use a system defined default value if this option is not specified.
DECDEL
Designates whether a period (.) or a comma (,) will be used as the decimal point indicator in decimal and floating point literals. This DRDA precompile/bind option is not supported by DB2. The DRDA server will use a system defined default value if this option is not specified.
DEFERRED_PREPARE
Provides a performance enhancement when accessing DB2 common server databases or DRDA databases. This option combines the SQL PREPARE statement flow with the associated OPEN, DESCRIBE, or EXECUTE statement flow to minimize inter-process or network flow.
DEGREE
Specifies whether or not the query is to be executed using I/O parallel processing.
DYNAMICRULES
Specifies which authorization identifier to use when dynamic SQL in a package is executed.
ENCODING
Specifies the encoding for all host variables in static statements in the plan or package.
EXPLAIN
Stores information in the Explain tables about the access plans chosen for each SQL statement in the package. DRDA does not support the ALL value for this option.
EXPLSNAP
Stores Explain Snapshot information in the Explain tables. This DB2 precompile/bind option is not supported by DRDA.
FEDERATED
Specifies whether a static SQL statement references a nickname or a federated view. SQL errors are returned if the package does not refer to a federated view or nickname and this option is specified, or if the package does refer to a federated view or nickname and the option is not specified.
FORMAT
Specifies the date and time format when date/time fields are assigned to string representations in host variables. DEF is a date and time format associated with the country code of the database.
FUNCPATH
Specifies the function path to be used in resolving user-defined distinct types and functions in static SQL. If this option is not specified, the default function path is:
GENERIC
Provides a means of passing new bind options to a target DRDA database. Each option must be separated by one or more spaces and enclosed in double quotes. For example:
GEN-INIT-FLAG
Generates the SQL-INIT-FLAG variable for DB2 for OS/390 compatibility. The flag is updated when the SQL environment is initialized. If you define this variable in your application, compile your application with this directive set to NOGEN-INIT-FLAG and the variable will not be generated by the precompiler.
GEN-SQLCA
Specifying this directive generates a SQLCA set of program variables equivalent to coding an EXEC SQL INCLUDE SQLCA statement in an application program.
HOSTVAR
Enables the HCO precompiler to compile a program when host variables are defined on multiple lines. If host variables are defined on multiple lines, the HCO precompiler generates a COBDB0100S error. If this error occurs, compile the program using DB2(HOSTVAR).
IGNORE-NESTED
In nested programs, specifies the program-id at which to start generating DB2 interface code. Any nested program encountered before the program-id is ignored and no DB2 interface code is generated. You must specify a program-id in the COBOL source code; otherwise, a compile error results. If you specify IGNORE-NESTED without a parameter, the program-id defaults to the program name with the filename extension replaced by .CBL.
IMMEDIATE
A synonym for directive CALL_RESOLUTION=IMMEDIATE.
IMMEDWRITE
Specifies whether or not to immediately write updates made to group buffer pool dependent pagesets or database partitions.
INIT
Makes the program initialize SQL. This option is disabled if it is used within an OO program.
INSERT
Allows a program being precompiled or bound from a DB2 V2.1 client to a DATABASE 2 Parallel Edition server to request that data inserts be buffered to increase performance.
ISOLATION
Determines how far a program bound to this package can be isolated from the effect of other executing programs. For more information about isolation levels, see the IBM DB2 SQL Reference.
KEEPDYNAMIC
Specifies whether or not to keep dynamic SQL statements after commit points.
LANGLEVEL
For more information about this option, see the IBM DB2 Application Programming Guide.
LEVEL
Defines the level of a module using the consistency token. The consistency token is any alphanumeric value up to 8 characters in length. The RDB package consistency token verifies that the requester's application and the relational database package are synchronized.
MSGAREA
Specifies the name of an alphanumeric data item. If this item is present in the program source it will automatically contain a description of a DB2 error condition (when SQLCODE is non zero).
MULTI-NESTED
Causes the precompiler to generate DB2 interface code in every routine in a source module including mutiple nested subroutines.
NOT
Specifies the character code to use for NOT character (¬).
OPTHINT
Specifies whether or not to use query optimization hints for static SQL.
OS400NAMING
Specifies which naming option is to be used when accessing DB2 for System i® data.
OWNER
Designates a 30-character authorization identifier for the package owner. The owner must have the privileges required to execute the SQL statements in the package. The default is the primary authorization ID of the precompile/bind process if this option has not been explicitly specified.
PASS
Specifies the userid and password to connect to the database with.
PRE
Enables DB2 programs to be animated or executed by pre-loading DB2 API routine entry points. Specify NOPRE if creating an executable or shared object file; otherwise, you may have link problems. For more information see the section Stand-alone DB2 Applications .
QUALFIX
Causes the DB2 ECM to append three characters to the name of the host variables when declaring them to DB2. This ensures problems caused by qualification (where two or more host variables have identical names when not qualified) are avoided but has the side-effect that:
QUALIFIER
Provides a -character implicit qualifier for unqualified table names, views, indexes, and aliases contained in the package. The default is the owner's authorization ID. The QUALIFIER directive is valid for local DB2 databases if used with the DB2 Universal Database 5.2 or later.
QUERYOPT
Indicates the desired level of optimization for all static SQL statements contained in the package. The default value is 5. For the complete range of optimization levels available, see the SET CURRENT QUERY OPTIMIZATION statement in the SQL Reference. This DB2 precompile/bind option is not supported by DRDA.
RELEASE
Indicates whether resources are released at each COMMIT point, or when the application terminates. This DRDA precompile/bind option is not supported by DB2.
REOPT
Specifies whether or not to have DB2 optimize an access path using values for host variables, parameter markers, global variables, and special registers.
REPLVER
Replaces a specific version of a package. The version identifier specifies which version of the package is to be replaced. Maximum length is 254 characters. REPLVER must follow immediately after ACTION=REPLACE or RETAIN if specified.
RETAIN
Indicates whether EXECUTE authorities are to be preserved when a package is replaced. If ownership of the package changes, the new owner grants the BIND and EXECUTE authority to the previous package owner.
SORTSEQ
Specifies which sort sequence table to use on the System i system.
SQLERROR
Indicates whether to create a package or a bind file if an error is encountered.
SQLFLAG
Identifies and reports on deviations from the SQL language syntax specified.
SQLRULES
Specifies whether type 2 CONNECTs are to be processed according to the DB2 rules or the Standard (STD) rules based on ISO/ANS SQL92.
SQLWARN
Indicates whether warnings will be returned from the compilation of dynamic SQL statements (via PREPARE or EXECUTE IMMEDIATE), or from describe processing (via PREPARE...INTO or DESCRIBE). This DB2 precompile/bind option is not supported by DRDA.
STATICREADONLY
Determines whether or not static cursors are treated as READ ONLY.
STRDEL
Designates whether an apostrophe (') or double quotation marks (") will be used as the string delimiter within SQL statements. This DRDA precompile/bind option is not supported by DB2. The DRDA server will use a system defined default value if this option is not specified.
SYNCPOINT
Specifies how commits or rollbacks are to be coordinated among multiple database connections.
TEXT
The description of a package. Maximum length is 255 characters. The default value is blanks. This DRDA precompile/bind option is not supported by DB2.
TRANSFORM-GROUP
Specifies the transform group name to be used for static SQL. This is a SQL identifier up to 18 characters in length.
UDB-VERSION
Specifies the version of DB2 Database for Linux, UNIX, and Windows (LUW) you want to use. For more information, see the section UDB-VERSION DB2 Directive Option in the chapter DB2 External Compiler Module of your Database Access book.
VALIDATE
Determines when the database manager checks for authorization errors and object not found errors. The package owner authorization ID is used for validity checking.
VERSION
Defines the version identifier for a package. The version identifier is any alphanumeric value, $, #, @, _, -, or ., up to 254 characters in length.
