Preparing DB2 Application Plans › Defining Packages › Creating a Package Definition › Package Parameters Fill-in

Package Parameters Fill-in

Issue the PARAMETERS command or press PF4/16 to display the package parameters fill-in. This fill-in lets you set DB2 BIND options for the package and specify whether programs in this package can execute SQL in dynamic mode. The current settings display as one-character codes that you can change by overtyping.

=>
=>
=>
----------------------------------------------------------------------------
IDEAL: PACKAGE PARAMETERS       PAC RATEPKG               SYS: DOC   FILL-IN

Bind Options:                                                                
Collection id: ___________________________
Name:  RATEPKG         Location:  ________
Owner: ________        Qualifier: ________

Action:    R (R=Replace, A=Add) 
Retain:    Y (Y=Yes, N=No)                                              
Validate:  R (R=Run, B=Bind)                                            
Isolation: R (R=Repeatable Read, C=Cursor Stability)                    
Flag:      I (I=InformationalWarningErrorCompletion,                 
              W=WarningErrorCompletion, E=ErrorCompletion,           
              C=Completion only)                                        
Acquire:   U (U=Use, A=Allocate)                                        
Release:   C (C=Commit, D=Deallocate)                                   
Explain:   N (Y=Yes, N=No)                                              

Prepare:   _ (N=NODefer, D=Defer)
Currentdata: _ (Y=Yes, N=No)
SQLError:    _ (N=NoPackage or C=Continue)
Enable/Disable:
________________________________________________________________________________

The following list provides an explanation of the fields on the preceding screen:

Collection ID

Identifies the collection where the package belongs. This name is used as the high-order qualifier of the package name.

Name

Specifies the name of the package supplied from the Identification fill-in.

Location

Specifies the location of the DBMS where the package is bound.

Owner

Specifies the authorization ID of the package owner.

Qualifier

Specifies the authorization ID that qualifies any unqualified SQL objects accessed in this package. An authorization ID specified in an ASSIGN AUTH command can override this value at runtime.

Action

Specifies whether this application package is new or replaces an old package.

• R-Replace old package
• A-Add new package

Retain

Indicates whether those users with authority to bind or execute the existing package keep that authority over the replaced package.

• Y-Retain authority
• N-Do not retain authority

Validate

Indicates when full validity checking is performed.

• R-At runtime
• B-At bind time

Isolation

Specifies the isolation of this application from others.

• R-Repeatable read
• C-Cursor stability

Flag

Indicates the level of messages to show.

• I- Informational, warning, error, and completion
• W- Warning, error, and completion
• E-Error and completion
• C- Completion only

Acquire

Indicates when you want the system to acquire the resources your program uses.

• U-Open table spaces and acquire locks when your application first accesses them
• A-Acquire them when the application package is allocated

Release

Indicates when you want the system to release the resources your program used.

• C-Release resources at each commit point
• D-Release them when the application terminates

Explain

Indicates whether to include the explain option.

• Y-Include the explain option
• N-Do not include the explain option

Currentdata

Specifies the data currency required for ambiguous cursors opened at remote locations. Data is considered current if the data in your host structure is identical to the data in the base table.

• Y-Data currency is required for ambiguous cursors
• N-Data currency is not required for ambiguous cursors

SQLError

Indicates whether you want to continue the package bind if SQL errors are detected during the package generation.

• N-Do not bind the package if SQL errors are detected
• C-Continue with the bind regardless of any SQL errors detected

Enable/Disable

These keywords are mutually exclusive. ENABLE lists the system connection types that are enabled to use the package. DISABLE lists the connection types that are disabled for the package. You can use one to three lines to enter the value for this parameter.