Gateway ADC Limitations

• The NO_DATA flag is not currently implemented on fetches. This may be fixed in future versions.
• The PRIVATE_DB and NO_UPDATE flags are not implemented. The state of records returned by fetches of uncommitted updates is determined by the SQL database, and currently there are no plans for their implementation.
• LOCK is implemented as a SELECT FOR UPDATE. Therefore all LOCKS are unlocked at the next commit() or decommit().
• The UNLOCK flag on fetches is implemented as a COMMIT WORK if there are no updates outstanding. Therefore any UNLOCK unlocks all locked records.
• All the flags that can be specified on rec_post() or rec_kill() e.g. parent checking, child deletion, are ignored. You may be able to use SQL database constraints to simulate their behaviour.
• In order to prevent looping all fetches on secondary indexes also use the whole of the primary key. In theory this could cause unusual applications to miss records.
• The rec_autoinc() function is only available for tables stored on an Oracle database, and only when AUXORACL is used in place of AUXWODBC.