ASA Programming Guide
Embedded SQL Programming
Embedded SQL is a database-programming interface for the C and C++ programming languages. It consists of SQL statements intermixed with (embedded in) C or C++ source code. These SQL statements are translated by a SQL preprocessor into C or C++ source code, which you then compile.
At runtime, embedded SQL applications use an Adaptive Server Anywhere interface library to communicate with database server. The interface library is a dynamic link library (DLL) or shared library on most platforms.
On Windows operating systems, the interface library is dblib9.dll.
On UNIX operating systems, the interface library is libdblib9.so, libdblib9.sl, or libdblib9.a, depending on the operating system.
Adaptive Server Anywhere provides two flavors of embedded SQL. Static embedded SQL is simpler to use but less flexible than dynamic embedded SQL. Both flavors are discussed in this chapter.
Development process overview
Running the SQL preprocessor
Supported compilers
Embedded SQL header files
Import libraries
A simple example
Structure of embedded SQL programs
Loading the interface library dynamically
Building NetWare Loadable Modules