ASA Programming Guide
Deploying Databases and Applications
Understanding installation directories and file names
Adaptive Server Anywhere uses consistent file naming conventions to help identify and group system components.
These conventions include:
Version number The Adaptive Server Anywhere version number is indicated in the filename of the main server components (.exe and .dll files).
For example, the file dbeng9.exe is a Version 9 executable.
Language The language used in a language resource library is indicated by a two-letter code within its filename. The two characters before the version number indicate the language used in the library. For example, dblgen9.dll is the language resource library for English. These two-letter codes are specified by ISO standard 639.
For more information about language labels, see Understanding the locale language.
You can download an International Resources Deployment Kit containing language resource deployment DLLs free of charge from the Sybase Web site.
To download the International Resources Deployment Kit from the Sybase Web site
Open the following URL in your Web browser:
Under the heading Downloads on the left hand side of the page, click EBFs/Patches.
Login to your Sybase Web account.
Click Create a New Account to create a Sybase Web account if you do not have one already.
From the list of available downloads, select the International Resources Deployment Kit that matches the platform and version of Adaptive Server Anywhere that you are currently using.
For a list of the languages available in Adaptive Server Anywhere, see Choosing collations.
The following table identifies the platform and function of Adaptive Server Anywhere files according to their file extension. Adaptive Server Anywhere follows standard file extension conventions where possible.
File extension | Platform | File type |
---|---|---|
.nlm | Novell NetWare | NetWare Loadable Module |
.chm, .chw | Windows | Help system file |
.lib | Varies by development tool | Static runtime libraries for the creation of embedded SQL executables |
.cfg, .cpr, .dat, .loc, .spr, .srt, .xlt | Windows | Sybase Adaptive Server Enterprise components |
.cmd .bat | Windows | Command files |
.res | NetWare, UNIX | Language resource file for non-Windows environments |
.dll | Windows | Dynamic Link Library |
.so .sl .a | UNIX | Shared object (Sun Solaris and IBM AIX) or shared library (HP-UX) file. The equivalent of a Windows DLL. |
Adaptive Server Anywhere databases are composed of two elements:
Database file This is used to store information in an organized format. This file uses a .db file extension.
Transaction log file This is used to record all changes made to data stored in the database file. This file uses a .log file extension, and is generated by Adaptive Server Anywhere if no such file exists and a log file is specified to be used. A mirrored transaction log has the default extension of .mlg.
Write file If your application uses a write file, it typically has a .wrt file extension.
Compressed database file If you supply a read-only compressed database file, it typically has extension .cdb.
These files are updated, maintained and managed by the Adaptive Server Anywhere relational database-management system.