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 (|).
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.
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.
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.
FOR プリコンパイラが更新可能なカーソルを変更して FOR UPDATE 句を追加するかどうかを指定します。
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:
INSERT DB2 Enterprise Server Edition サーバーに対してプログラムをプリコンパイルまたはバインドして、パフォーマンス向上のためにデータ挿入のバッファーを要求することを許可します。
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.
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).
OS400NAMING DB2 for System i® のデータにアクセスする際に、どの命名オプションを使用するかを指定します。
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.
PRE 実行時に関連する DB2 モジュールを動的にロードするコードを生成するようにプリプロセッサに指示します。
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.
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.
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 使用する Linux、UNIX、および Windows (LUW) 用 DB2 データベースのバージョンを指定します。
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.
XAID Simplifies working with multiple XARs of the DB2 RM type defined in a single エンタープライズ サーバー リージョン.