The following fields and controls are used in the Rebind 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 package selected from the Package drop-down list. You cannot modify this field.
- Package Name
- The name of the package selected from the Package drop-down list. You cannot modify this field.
- Package
- The drop-down list contains all of the packages on the host that are owned by the current SQLID.
- 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.
The options are:
- 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.
- Bind
- To set optional parameters for the package you are rebinding, click the Bind button.
