ASA Programming Guide
The Database Tools Interface
Sybase Adaptive Server Anywhere includes Sybase Central and a set of utilities for managing databases. These database management utilities carry out tasks such as backing up databases, creating databases, translating transaction logs to SQL, and so on.
All the database management utilities use a shared library called the database tools library. It is supplied for each of the Windows operating systems. The name of this library is dbtool9.dll.
You can develop your own database management utilities or incorporate database management features into your applications by calling the database tools library. This chapter describes the interface to the database tools library. In this chapter, we assume you are familiar with how to call DLLs from the development environment you are using.
The database tools library has functions, or entry points, for each of the database management utilities. In addition, functions must be called before use of other database tools functions and when you have finished using other database tools functions.
The dbtool9.dll library is supplied for Windows CE, but includes only entry points for DBToolsInit, DBToolsFini, DBRemoteSQL, and DBSynchronizeLog. Other tools are not provided for Windows CE.
The dbtools header file included with Adaptive Server Anywhere lists the entry points to the DBTools library and also the structures used to pass information to and from the library. The dbtools.h file is installed into the h subdirectory under your installation directory. You should consult the dbtools.h file for the latest information about the entry points and structure members.
The dbtools.h header file includes two other files:
sqlca.h This is included for resolution of various macros, not for the SQLCA itself.
dllapi.h Defines preprocessor macros for operating-system dependent and language-dependent macros.
Also, the sqldef.h header file includes error return values.