Imported Tables

The lock timeout is separately set per database type. Therefore if a lock timeout is set, say, for Adaptive Server Anywhere, it will be set on all imported tables that use Adaptive Server Anywhere.

Full set of tests do not require testing every database with every other database. This set of tests should be sufficient:

 

Main DB

Other DB

Other DB

Other DB

Test Set 1

ASA

SQL Server

Oracle (C)

MS Access

Test Set 2

SQL Server

ASA

MySQL

 

Test Set 3

Oracle (C)

 

 

 

Test Set 4

Oracle (S)

SQL Server

 

 

 

 

The first 3 tests are to use LOCK_TYPE=C for all databases.

Test Set 4 should use LOCK_TYPE=S for Oracle and of course LOCK_TYPE=C for SQL Server.