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

SQL Anywhere 12.0.1 » 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

Development process overview
The SQL preprocessor
Supported compilers
Embedded SQL header files
Import libraries
Sample embedded SQL program
Structure of embedded SQL programs
DBLIB dynamic loading under Windows
Sample embedded SQL programs
Embedded SQL data types
Host variables in embedded SQL
The SQL Communication Area (SQLCA)
Static and dynamic SQL
The SQL descriptor area (SQLDA)
Fetching data
Sending and retrieving long values
Simple stored procedures in embedded SQL
Request management with embedded SQL
Database backup with embedded SQL
Library function reference
Embedded SQL statement summary