EasyManuals Logo

IBM DB2 User Manual

IBM DB2
585 pages
To Next Page IconTo Next Page
To Next Page IconTo Next Page
To Previous Page IconTo Previous Page
To Previous Page IconTo Previous Page
Page #442 background imageLoading...
Page #442 background image
This option corresponds to the
DYNAMICRULES(INVOKERUN) bind option.
3 When the package is run as or runs under a stored procedure
or user-defined function package, the database server processes
dynamic SQL statements using invoke behavior. Otherwise, the
database server processes dynamic SQL statements using bind
behavior.
This option corresponds to the
DYNAMICRULES(INVOKEBIND) bind option.
4 When the package is run as or runs under a stored procedure
or user-defined function package, the database server processes
dynamic SQL statements using define behavior. Otherwise, the
database server processes dynamic SQL statements using run
behavior.
This option corresponds to the
DYNAMICRULES(DEFINERUN) bind option.
5 When the package is run as or runs under a stored procedure
or user-defined function package, the database server processes
dynamic SQL statements using define behavior. Otherwise, the
database server processes dynamic SQL statements using bind
behavior.
This option corresponds to the
DYNAMICRULES(DEFINEBIND) bind option.
packageOwnerIdentifier
Specifies the authorization ID of the owner of the packages.
isolationLevel
Specifies how far to isolate an application from the effects of other
running applications. Possible values are:
1 Uncommitted read
This option corresponds to the ISOLATION(UR) bind option.
2 Cursor stability
This option corresponds to the ISOLATION(CS) bind option.
3 Read stability
This option corresponds to the ISOLATION(RS) bind option.
4 Repeatable read
This option corresponds to the ISOLATION(RR) bind option.
releasePackageResourcesAtCommit
Specifies when to release resources that a program uses at each commit
point. Possible values are:
true This option corresponds to the RELEASE(COMMIT) bind
option.
false This option corresponds to the RELEASE(DEALLOCATE) bind
option.
If -bindoptions is specified, -generic must also be specified.
426 Application Programming Guide and Reference for Java
â„¢
|
|
||
|
|
|
|
|
|
||
|
|
|
|
|
|
||
|
|
|
|
|
|
|
|
|
|
|
||
|
||
|
||
|
||
|
|
|
|
||
|
||
|
|

Table of Contents

Questions and Answers:

Question and Answer IconNeed help?

Do you have a question about the IBM DB2 and is the answer not in the manual?

IBM DB2 Specifications

General IconGeneral
DeveloperIBM
Initial Release1983
LicenseProprietary
Written inC, C++
CategoryDatabase Management System (RDBMS)
Operating SystemLinux, Windows
Programming LanguagesC, C++
Data ModelsRelational
EditionsCommunity, Standard, Advanced
Key Featureshigh availability, scalability