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.
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
Discuss this page in DocCommentXchange.
|
Copyright © 2010, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.0 |