Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SAP Sybase SQL Anywhere 16.0 » SQL Anywhere Server - Database Administration » Database configuration » File locations and installation settings


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.

Simple file searching
Extensive file searching on Windows
Extensive file searching on Windows Mobile
Extensive file searching on Unix