EasyManuals Logo

IBM DB2 User Manual

IBM DB2
585 pages
To Next Page IconTo Next Page
To Next Page IconTo Next Page
To Previous Page IconTo Previous Page
To Previous Page IconTo Previous Page
Page #416 background imageLoading...
Page #416 background image
-bindoptions options-string
Specifies a list of options, separated by spaces. These options have the same
function as DB2 precompile and bind options with the same names. If you are
preparing your program to run on a DB2 for z/OS system, specify DB2 for
z/OS options. If you are preparing your program to run on a DB2 Database for
Linux, UNIX, and Windows system, specify DB2 Database for Linux, UNIX,
and Windows options.
Notes on bind options:
v Specify ISOLATION only if you also specify the -singlepkgname option.
Important: Specify only those program preparation options that are
appropriate for the data source at which you are binding a package. Some
values and defaults for the IBM Data Server Driver for JDBC and SQLJ are
different from the values and defaults for DB2.
-storebindoptions
Specifies that values for the -bindoptions and -staticpositioned parameters are
stored in the serialized profile. If db2sqljbind is invoked without the
-bindoptions or -staticpositioned parameter, the values that are stored in the
serialized profile are used during the bind operation. When multiple serialized
profiles are specified for one invocation of db2sqljcustomize, the parameter
values are stored in each serialized profile. The stored values are displayed in
the output from the db2sqljprint utility.
-collection collection-name
The qualifier for the packages that db2sqljcustomize binds. db2sqljcustomize
stores this value in the customized serialied profile, and it is used when the
associated packages are bound. If you do not specify this parameter,
db2sqljcustomize uses a collection ID of NULLID.
-onlinecheck YES|NO
Specifies whether online checking of data types in the SQLJ program is to be
performed. The -url or -datasource option determines the data source that is to
be used for online checking. The default is YES if the -url or -datasource
parameter is specified. Otherwise, the default is NO.
-qualifier qualifier-name
Specifies the qualifier that is to be used for unqualified objects in the SQLJ
program during online checking. This value is not used as the qualifier when
the packages are bound.
-rootpkgname|-singlepkgname
Specifies the names for the packages that are associated with the program. If
-automaticbind is NO, these package names are used when db2sqljbind runs.
The meanings of the parameters are:
-rootpkgname package-name-stem
Specifies that the customizer creates four packages, one for each of the four
DB2 isolation levels. The names for the four packages are:
package-name-stem1
For isolation level UR
package-name-stem2
For isolation level CS
package-name-stem3
For isolation level RS
package-name-stem4
For isolation level RR
400 Application Programming Guide and Reference for Java
â„¢

Table of Contents

Questions and Answers:

Question and Answer IconNeed help?

Do you have a question about the IBM DB2 and is the answer not in the manual?

IBM DB2 Specifications

General IconGeneral
DeveloperIBM
Initial Release1983
LicenseProprietary
Written inC, C++
CategoryDatabase Management System (RDBMS)
Operating SystemLinux, Windows
Programming LanguagesC, C++
Data ModelsRelational
EditionsCommunity, Standard, Advanced
Key Featureshigh availability, scalability