Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 17 » SQL Anywhere Server - Programming

Embedded SQL

SQL statements embedded in a C or C++ source file are referred to as Embedded SQL. A preprocessor translates these statements into calls to a runtime library. Embedded SQL is an ISO/ANSI and IBM standard.

Embedded SQL is portable to other databases and other environments, and is functionally equivalent in all operating environments. It is a comprehensive, low-level interface that provides all the functionality available in the product. Embedded SQL requires knowledge of C or C++ programming languages.

Embedded SQL applications

You can develop C or C++ applications that access the database server using the Embedded SQL interface. The command line database tools are examples of applications developed in this manner.

Applications connecting to the database server using Embedded SQL.

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 Embedded SQL preprocessor into C or C++ source code, which you then compile.

At runtime, Embedded SQL applications use an 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 dblib17.dll.

  • On Unix operating systems, the interface library is,, or libdblib17.a, depending on the operating system.

  • On Mac OS X, the interface library is libdblib17.dylib.1.

Two flavors of Embedded SQL are provided. Static Embedded SQL is simpler to use, but is less flexible than dynamic Embedded SQL.