Bind Package Dialog Box

The following fields and controls are used in the Bind Package dialog box:

Bind Location
The Remote Location you selected in the Bind Utility main window. You cannot modify this field. Click Cancel to return to the main window if you need to select a different Remote Location.
Collection Identifier
The Collection ID of the DBRM you select from the DBRM File Name drop-down list. You cannot modify this field.
Package Name
The package name of the DBRM you select from the DBRM File Name drop-down list. The Bind Utility assigns this name to the package it creates. You cannot modify this field.
DBRM File Name
The drop-down list contains all of the DBRMs (.DBR files) in the XDB application directory on your workstation.
Package Version
If you are maintaining multiple versions of a program, assign a different number for each version of the package. This field is optional.
Note:

If the host on which you are binding this package does not support package versions, leave this field blank.

Isolation Level
Controls the manner in which locks are acquired and released by the system.
No Commit
Allows your program to read modified records even if they haven’t been committed by another process.
Change
If you are using a read-only cursor:
  • Allows your program to read modified records even if they haven’t been committed by another process.
  • Allows other processes to change a record that your application reads, even if your cursor is on that record.

If you are using a non-read-only cursor:

  • Prevents your program from reading a modified record that hasn’t been committed by another process.
  • Prevents other processes from changing a record while your cursor is on it.
Cursor Stability
Allows other processes to change a row that your application reads, but does not change, as long as your cursor is not on that row.

Prevents other processes from changing records that your application has changed until your program commits them or terminates.

Prevents your program from reading a modified record that hasn’t been committed by another process.

All
Prevents other processes from changing records that are read or changed by your application until your program commits them or terminates.

Prevents your application from retrieving a modified record that hasn’t yet been committed by another process when it opens a read-only database cursor.

If your program opens the same query during a single unit of work under this isolation level, the results table may differ from the previous one because it may include committed changes from other processes.

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.

Prevents the application from reading a modified record that hasn’t 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 will be identical to the previous table. However, it may contain updates made by your program.

No Commit
Allows your program to read modified records even if they haven't been committed by another process.
Change
If you are using a read-only cursor:
  • Allows your program to read modified records even if they haven't been committed by another process.
  • Allows other processes to change a record that your application reads, even if your cursor is on that record.

If you are using a non-read-only cursor:

  • Prevents your program from reading a modified record that hasn't been committed by another process.
  • Prevents other processes from changing a record while your cursor is on it.
Cursor Stability
Allows other processes to change a row that your application reads, but does not change, as long as your cursor is not on that row.

Prevents other processes from changing records that your application has changed until your program commits them or terminates.

Prevents your program from reading a modified record that hasn't been committed by another process.

All
Prevents other processes from changing records that are read or changed by your application until your program commits them or terminates.

Prevents your application from retrieving a modified record that hasn't yet been committed by another process when it opens a read-only database cursor.

If your program opens the same query during a single unit of work under this isolation level, the results table may differ from the previous one because it may include committed changes from other processes.

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.

Prevents the application from reading a modified record that hasn't 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 will be identical to the previous table. However, it may contain updates made by your program.

Action
One of the following options:
  • Replace replaces an existing package with a new package. To replace the version label, enter a new label in the Replace Version field in the Bind Options dialog box.
  • Add creates a new package if one does not already exist. If a package with the current Collection ID already exists, the bind process will fail.
Bind
To set optional parameters for the bind, click the Bind button. This command button is available only when you select a file from the DBRM File Name drop-down list.
Format
To specify data formats associated with the selected DBRM, click the Format button. This command button is available only when you select a file from the DBRM File Name drop-down list.