If -longpkgname is not specified, package-name-stem must be an
alphanumeric string of seven or fewer bytes.
If -longpkgname is specified, package-name-stem must be an alphanumeric
string of 127 or fewer bytes.
-singlepkgname package-name
Specifies that the customizer creates one package, with the name
package-name. If you specify this option, your program can run at only one
isolation level. You specify the isolation level for the package by specifying
the ISOLATION option in the -bindoptions options string.
If -longpkgname is not specified, package-name must be an alphanumeric
string of eight or fewer bytes.
If -longpkgname is specified, package-name must be an alphanumeric string
of 128 or fewer bytes.
Using the -singlepkgname option is not recommended.
Recommendation: If the target data source is DB2 for z/OS, use uppercase
characters for the package-name-stem or package-name value. DB2 for z/OS
systems that are defined with certain CCSID values cannot tolerate lowercase
characters in package names or collection names.
If you do not specify -rootpkgname or -singlepkgname, db2sqljcustomize
generates four package names that are based on the serialized profile name. A
serialized profile name is of the following form:
program-name_SJProfileIDNumber.ser
The four generated package names are of the following form:
Bytes-from-program-nameIDNumberPkgIsolation
Table 92 shows the parts of a generated package name and the number of
bytes for each part.
The maximum length of a package name is maxlen. maxlen is 8 if -longpkgname
is not specified. maxlen is 128 if -longpkgname is specified.
Table 92. Parts of a package name that is generated by db2sqljcustomize
Package name part Number of bytes Value
Bytes-from-program-name m=min(Length(program-name),
maxlen–1–Length(IDNumber))
First m bytes of program-name,in
uppercase
IDNumber Length(IDNumber) IDNumber
PkgIsolation 1 1, 2, 3, or 4. This value represents the
transaction isolation level for the
package. See Table 93.
Table 93 shows the values of the PkgIsolation portion of a package name that is
generated by db2sqljcustomize.
Table 93. PkgIsolation values and associated isolation levels
PkgNumber value Isolation level for package
1 Uncommitted read (UR)
2 Cursor stability (CS)
3 Read stability (RS)
Chapter 7. JDBC and SQLJ reference information 401
To Next Page
Loading...
Need help?
General