Q: If I create a table using ODBC and SQL, how do I know which library the table will be created in?
A: If you qualify the name of the table with a specific library within the SQL statement, the table will be created in that library. For example, consider the following statement:
CREATE TABLE LIB1.TABLE ....
In this case, the table will be created in LIB1. If you don't qualify the name of the table in the SQL statement, the Client Access ODBC driver will use the first library specified in the Default Libraries entry of the driver configuration panel. If there are no entries in this list, Client Access will try to find a library with the same name as the user profile currently signed on to Client Access. If this library is not found, it will abort with an error.
- Brian Singleton