How SQL Anywhere locates files

The client library and the database server need to locate files for two main purposes:

DLLs and initialization files are required to run SQL Anywhere. If an incorrect DLL is located, there is the possibility of version mismatch errors.
Some files are specified in SQL statements and need to be located at run time, such as INSTALL JAVA or LOAD TABLE.

Examples of SQL statements that use file names include the following:

INSTALL JAVA statement The name of the file that holds Java classes.
LOAD TABLE and UNLOAD TABLE statements The name of the file from which data should be loaded or to which the data should be unloaded.
CREATE DATABASE statement A file name is needed for this statement and similar statements that can create files.

Sometimes SQL Anywhere uses a simple algorithm to locate files. In other cases, a more extensive search is performed.

Discuss this page in DocCommentXchange.