*GrantExecute
|
An indicator to grant privileges on the
package that you are creating.
|
*GrantAuthid
|
The ID of the person to whom the GrantExecute privileges were assigned. The
default value is Grant Execute privileges on
the package to PUBLIC.
|
*IsolationLevel
|
Select the isolation level method by which locks are acquired and released by the system. Valid
values are: -
ALL – prevents any other process from accessing data that
your application has read or modified. All read or
modified data is locked until the end of the
transaction.
-
CHANGE – allows other processes to read from the
database. Only modified data is locked until the end of
the transaction
-
Cursor_Stability (the default) – allows other processes
to change a row that your application has read if the
cursor is not on the row you want to change. Prevents
other processes from changing records that your
application has changed until your program commits them
or terminates. It prevents your program from reading a
modified record that has not been committed by another
process.
-
No_Commit – allows your program to read modified records
even if they have not been committed by another
person.
-
Repeatable_Read – prevents other processes from changing
records that are read or changed by your application
(including phantom records) until your program commits
them or terminates. It prevents the application from
reading modified records that have not been committed by
another process. If your program opens the same query
during a single unit of work under this isolation level,
the results table is identical to the previous table;
however, it can contain updates made by your
program.
|
*DynamicSections
|
The number of statements that the DB2 Wire Protocol driver package can prepare for a single user.
The default is 64. This value determines the maximum cursors or
dynamic statements that a single connection can have open
simultaneously.
|