Use this page to specify the properties for each package in the
project.
The first field on this page is a list of the packages that are defined
for the project. To add a package, click
Add Package.
- Package name
- The name of the package that the bind process
will generate. By default, the maximum length of the name is 8 characters.
If the database that you are using supports long package names, and if the
long package name option is set on the SQLJ page in the project properties,
the maximum length is 128 characters. If you select the All isolation
levels option in the Isolation field, the
digit 1, 2, 3, or 4 is appended to the root name to create the four final
package names (one for each isolation level).
- Database name
- The name of the database to which the profiles
in the package are bound. The list includes the names of the databases
that are defined on the Databases page.
- Isolation
- Determines how far a program that is bound to
this package can be isolated from the effect of other processes that are running
on the same database.
- All isolation levels
- Applies the restrictions that are imposed by all four isolation levels.
- Cursor Stability
- Another process cannot change the row of data that the cursor points to.
- Repeatable Read
- Another process cannot change the rows of data that the program reads
or changes until the logical unit of work ends.
- Read Stability
- Another process cannot change the rows of data that the program reads
until the logical unit of work ends.
- Uncommitted Read
- With a read-only cursor, another process can change the rows of data that
the program reads.
- Options
- The list of parameters for the command that is
selected on the Command page, other than url, user, password,
and the SQLJ profile name. The parameters that you specify on this page
apply only to the selected package.
- Profiles in package
- Shows the profiles that are associated with the
package. To add a profile to the package, click Add Profiles
to Package.