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

SQL Anywhere 12.0.0 (Français) » 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
Running the SQL preprocessor
Supported compilers
Embedded SQL header files
Import libraries
Sample embedded SQL program
Structure of embedded SQL programs
Loading DBLIB dynamically under Windows
Sample embedded SQL programs
Embedded SQL data types
Using host variables
The SQL Communication Area (SQLCA)
Static and dynamic SQL
The SQL descriptor area (SQLDA)
Fetching data
Sending and retrieving long values
Using simple stored procedures
Embedded SQL programming techniques
SQL preprocessor
Library function reference
Embedded SQL statement summary