Table 93. PkgIsolation values and associated isolation levels (continued)
PkgNumber value Isolation level for package
4 Repeatable read (RR)
Example: Suppose that a profile name is ThisIsMyProg_SJProfile111.ser. The
db2sqljcustomize option -longpkgname is not specified. Therefore,
Bytes-from-program-name is the first four bytes of ThisIsMyProg, translated to
uppercase, or THIS. IDNumber is 111. The four package names are:
THIS1111
THIS1112
THIS1113
THIS1114
Example: Suppose that a profile name is ThisIsMyProg_SJProfile111.ser. The
db2sqljcustomize option -longpkgname is specified. Therefore,
Bytes-from-program-name is ThisIsMyProg, translated to uppercase, or
THISISMYPROG. IDNumber is 111. The four package names are:
THISISMYPROG1111
THISISMYPROG1112
THISISMYPROG1113
THISISMYPROG1114
Example: Suppose that a profile name is A_SJProfile0.ser. Bytes-from-program-
name is A. IDNumber is 0. Therefore, the four package names are:
A01
A02
A03
A04
Letting db2sqljcustomize generate package names is not recommended. If any
generated package names are the same as the names of existing packages,
db2sqljcustomize overwrites the existing packages. To ensure uniqueness of
package names, specify -rootpkgname.
-longpkgname
Specifies that the names of the DB2 packages that db2sqljcustomize generates
can be up to 128 bytes. Use this option only if you are binding packages at a
server that supports long package names. If you specify -singlepkgname or
-rootpkgname, you must also specify -longpkgname under the following
conditions:
v The argument of -singlepkgname is longer than eight bytes.
v The argument of -rootpkgname is longer than seven bytes.
-staticpositioned NO|YES
For iterators that are declared in the same source file as positioned UPDATE
statements that use the iterators, specifies whether the positioned UPDATEs
are executed as statically bound statements. The default is NO. NO means that
the positioned UPDATEs are executed as dynamically prepared statements.
-zosDescProcParms
Specifies that DB2 for z/OS performs a DESCRIBE operation on stored
procedure parameters.
-zosDescProcParms applies to programs that are to be run on DB2 for z/OS
database servers only.
If DESCRIBE information is available, SQLJ has information about the length
and precision of INOUT and OUT parameters, so it allocates only the amount
of memory that is needed for those parameters. Availability of DESCRIBE
402 Application Programming Guide and Reference for Java
™
To Next Page
Loading...
Need help?
General