skip to main content

Differences between Database Bridge and ISAM

Differences between Database Bridge and ISAM
The Database Bridge allows to keep the same approach used for ISAM files despite it works on a relational database. However there are few differences between the standard ISAM and the ISAM simulated by the Database Bridge. These differences are discussed below.
Locks Management
To emulate the COBOL locks behavior, the Database Bridge takes advantages of specific database features that are different from database to database.
The lock of a single record is fully supported when using Oracle, Informix, MS SQL Server, MySQL, DB2 and PostgreSQL.
The lock on multiple records is not officially supported. The Database Bridge always takes one lock at a time because it re-uses the same ESQL cursor for reading a record with lock. If the program locks multiple records working, it depends by a database configuration that keeps locks alive.
The lock a whole file/table is supported when using Oracle, Informix, MS SQL Server, DB2 and PostgreSQL. MySQL does not support the ability to lock a whole file/table.
The following operations are not currently supported by the Veryant Database Bridge. Contact Veryant if you need any of these capabilities:
In order to manage locks on MySQL, the following setting should be present in the configuration:
Note: If you're working in a Application Server (Thin Client) or File Server environment and you wish to have a full support for locking features, then you may consider handling locks through the Internal lock management.
Moving among duplicate key values
When you change the order of read (e.g. you perform a READ NEXT after a READ PREVIOUS or a READ PREVIOUS after a READ NEXT) among duplicated values of an alternate key, the EDBI routine retrieves the first record whose key value doesn't match with the current one.
A practical example follows.
Suppose to have a file with the following content:
The table below lists a series of operations and tells which record is read by ISAM file handlers like JIsam or c-tree versus the record read by the Database Bridge:

Copyright (c) 2017 Veryant
Contact us
Please share your comments on this manual or on any
Veryant product documentation with the email button at the top left