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 a SQL Anywhere interface library called DBLIB to communicate with a database server. DBLIB is a dynamic link library (DLL) or shared object on most platforms.
On Windows operating systems, the interface library is dblib11.dll.
On Unix operating systems, the interface library is libdblib11.so, libdblib11.sl, or libdblib11.a, depending on the operating system.
On Mac OS X, the interface library is libdblib11.dylib.1.
SQL Anywhere provides two flavors of embedded SQL. Static embedded SQL is simpler to use, but is less flexible than dynamic embedded SQL.
Development process overview
Running the SQL preprocessor
Embedded SQL header files
A simple example
Structure of embedded SQL programs
Loading DBLIB dynamically under Windows
|Discuss this page in DocCommentXchange.
Send feedback about this page using email.
|Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1|