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