Restriction: This topic applies only when a Database Connectors license has been installed via the Micro Focus License Management System.

For some large databases, the API function SQLTables(), which is called to get a list of the tables and information about them, sometimes takes a long time to execute. If you are experiencing such problems, you can instruct the interface to build a test SQL query and use the API function call SQLNumResultTables() to determine if the table exists. This may improve performance for large databases.

To turn on this new functionality, set the A_DB2_USE_SQLTABLES configuration variable to FALSE. The default value of this variable is TRUE, which means the interface uses the SQLTables() API function.