Reference Manual
   CHAPTER 1. File Locations and Installation Settings     

How Adaptive Server 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 Adaptive Server 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 or LOAD TABLE.

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

• INSTALL 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.(such as CREATE WRITEFILE).

In some cases, Adaptive Server Anywhere uses a simple algorithm to locate files. In other cases, a more extensive search is carried out.

Simple file searching 

In many SQL statements (such as LOAD TABLE, or CREATE DATABASE), the file name is interpreted as relative to the current working directory of the database server.

Also, when a database server is started and a database file name (DBF parameter) is supplied, the path is interpreted as relative to the current working directory.

Extensive file searching 

Adaptive Server Anywhere programs, including the database server and administration utilities, carry out a more extensive search for required files, such as DLLs or shared libraries. In these cases, Adaptive Server Anywhere programs look for files in the following order:

1. The executable directory     The directory in which the program executable is held. Also, directories with the following paths relative to the program executable directory:

   • Parent of the executable directory

   • A child of the parent directory named scripts The UNIX server does not search in this location.

2. Current working directory     When a program is started, it has a current working directory (the directory from which it is started). This directory is searched for required files.

3. Location registry entry     On installation, Adaptive Server Anywhere adds a LOCATION registry entry. The indicated directory is searched, followed by the following:

   • A child named scripts

   • A child with the operating system name (win32, win, and so on).

4. System specific directories     This includes directories where common operating system files are held, such as the Windows directory and the Windows\system directory on Windows and Windows NT operating systems.

5. CLASSPATH directories     For Java files, directories listed in the CLASSPATH environment variable are searched to locate files.

6. PATH directories     Directories in the system path and the user's path are searched to locate files.