ACCESS Specifies the name of the package to be created and stored in the database.
ACTION Indicates whether the package can be added or replaced.
ALEBRA When CHARSET(EBCDIC) is also specified, suppresses generation of ASCII/EBCDIC data translation in host variables used in SQL
statements.
APREUSE Specifies whether or not to reuse static SQL access plans.
BIND Instructs the DB2 ECM to create a DBRM file to use for manual binding. Also optionally used to specify an alternative filename
for and/or path to the created DBRM file.
BINDDIR Specifies an alternative directory in which to write the DBRM file created during compilation.
BGP Specifies the type of background syntax checking to be done by the DB2 ECM preprocessor when a program is being edited in
Enterprise Developer.
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-HV-FROM-GROUP Generates host variables for all elementary data items when a multiple-level group variable is used in a FETCH or singleton
SELECT DB2 statement.
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.
HCO Causes the DB2 ECM to execute in MFHCO mode, enabling the use of CHARSET EBCDIC, as well as supporting some mainframe DB2
SQL syntax.
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, indicates the program or programs for which to generate DB2 interface code.
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 and/or exit handling code to ensure rollback to the last commit point in the case of an abnormal
termination.
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_PACKAGE Enables the preprocessor to generate a BND file and package for the main program and each of the nested programs contained
in a given source file.
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.
OPTPER Causes the DB2 ECM to optimize the performance of CHARSET"EBCDIC" processing.
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.
PACKAGE Specifies the name of the package to be created and stored in the database.
PASS Supplies login credentials required to connect to a DB2 database.
PRE Instructs the preprocessor to generate code that dynamically loads associated DB2 modules at run time.
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.
QUALIFY-CALL Works with the DB2 QUALIFIER directive to modify EXEC SQL CALL statements by attaching the schema name to the stored procedure
name.
QUERYOPT Indicates the desired level of optimization for all static SQL statements contained in the package.
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.
SAVE-RETURN-CODE When calling DB2 LUW functions, specifies whether or not to save and then restore RETURN-CODE.
SINGLE_PACKAGE Enables the preprocessor to generate one BND file and package for the main program all of the nested programs contained in
a given source file.
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.
STOPROC On entering a stored procedure, converts character data on DB2 LUW stored procedure parameters to CHARSET(EBCDIC), and converts
it back to CHARSET(ASCII) on exiting the stored procedure.
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.
TEMPORAL-HISTORY Specifies whether or not changes to data in system-period temporal tables made by static or dynamic SQL statements make changes
to the corresponding history table.
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.
XAID Simplifies working with multiple XARs of the DB2 RM type defined in a single enterprise server region.