Bind files for REXX
Five bind files are
provided to support REXX applications.
The names of these files are included in the DB2UBIND.LST file. Each
bind file is precompiled using a different isolation level; therefore,
there are five different packages stored in the database.
The five bind files are:
- DB2ARXCS.BND
- Supports the cursor stability isolation level.
- DB2ARXRR.BND
- Supports the repeatable read isolation level.
- DB2ARXUR.BND
- Supports the uncommitted read isolation level.
- DB2ARXRS.BND
- Supports the read stability isolation level.
- DB2ARXNC.BND
- Supports the no commit isolation level. This isolation level is used when working with some host or System i database servers. On other databases, it behaves such as the uncommitted read isolation level.
Note: In some cases, it can be necessary to explicitly bind
these files to the database.
When you use the SQLEXEC routine, the package created with cursor stability is used as a default. If you require one of the other isolation levels, you can change isolation levels with the SQLDBS CHANGE SQL ISOLATION LEVEL API, before connecting to the database. This will cause subsequent calls to the SQLEXEC routine to be associated with the specified isolation level.
Windows-based REXX applications cannot assume that the default isolation level is in effect unless they know that no other REXX programs in the session have changed the setting. Before connecting to a database, a REXX application should explicitly set the isolation level.