Bind Package Dialog Box

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.

The Collection ID of the DBRM you select from the DBRM File Name drop-down list. You cannot modify this field.

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.

The drop-down list contains all of the DBRMs (.DBR files) in the XDB application directory on your workstation.

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.

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.

Allows your program to read modified records even if they haven't been committed by another process.

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.

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.

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.

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.

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.

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.

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.