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.
APREUSE
Specifies whether or not to reuse static SQL access plans.
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 (|).
CONCURRENTACCESSRESOLUTION
Specifies the concurrent access resolution to use for statements in the package.
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.
DBPROTOCOL
Specifies what protocol to use when connecting to a remote site that is identified by a three-part name statement.
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.
EXTENDEDINDICATOR
Enables the recognition of extended indicator variable values during the execution of the associated plan or package.
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.
FEDERATED_ASYNCHRONY
Specifies the maximum number of asynchrony table queues (ATQs) that the federated server supports in the access plan for programs that use embedded SQL.
FOR
Specifies whether or not the precompiler modifies the updatable cursor to add a FOR UPDATE clause.
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
Generates an SQLCA set of program variables equivalent to coding an EXEC SQL INCLUDE SQLCA statement in an application program.
HOSTVAR
Enables the precompiler to compile a program when host variables are defined on multiple lines. If host variables are defined on multiple lines, the precompiler generates a COBDB0100S error. If this error occurs, compile the program using DB2(HOSTVAR).
HSFTRACE
Generates calls around each SQL statement to the HSF trace routine if the application is running under Enterprise Server. In some cases, the application must be linked with mfsqlSMF.lib.
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
Generates a CONNECT statement to initialize SQL. This option is disabled if it is used within an OO program.
INSERT
Allows a program being precompiled or bound against a DB2 Enterprise Server 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 (¬).
OPTPROFILE
Specifies the name of an existing optimization profile to be used for all static statements in the package.
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 user ID and password to use when connecting to the database. If not specified, the values set for the DB2_USERNAME and DB2_PASSSWORD environment variables are used.
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.
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 DB2 error messages sometimes display the names of host variables with the three additional characters appended to them.
QUALIFIER
Provides a 128-character implicit qualifier for unqualified table names, views, indexes, and aliases contained in the package. The default is the owner's authorization ID.
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.
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.
