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.