skip to main content
Part 2: The 32-Bit/64-Bit Drivers : The DB2 Wire Protocol Driver : Connection Option Descriptions : Package Name Prefix
  
Package Name Prefix
Attribute
PackageNamePrefix (PNP)
Purpose
Specifies a two-character prefix used for package names when the driver executes dynamic SQL. The default package name uses the following syntax:
DDOiVRMx
where:
DD
is the two-character prefix.
i
is one of the following characters:
S—Serializable : DB2 RR
R—Repeatable Read : DB2 RS
C—Committed Read : DB2 CS
U—Uncommitted Read : DB2 UC
N—Not committed: DB2 NC
VRM
is the Version Release Modification, for example, you can specify 520 to represent version 5.2.0.
x
is a one-character suffix that specifies:
A—Cursor queries/updates
B—Cursor queries/updates with hold
C—Stored procedures (section 1 is for stored procedures that do not have parameters; section 2 is for procedures that do have parameters)
For example, the package name DDOC520A would represent a package using the Committed Read isolation level, at version 5.20, and using cursor queries/updates.
Valid Values
xx
where:
xx
is a two-character prefix.
Default
DD
GUI Tab
Advanced tab