User's Guide

Part V. The SQL Anywhere Programming Interfaces

About this chapter

This chapter describes the Embedded SQL interface to SQL Anywhere database engines.

Structure packing must be turned on All Embedded SQL programs must be compiled with the structure packing option of the compiler set to one-byte alignment (usually the default).

Embedded SQL development

Embedded SQL interface data types

Host variables

The SQL communication area (SQLCA)

Fetching data

Static vs dynamic SQL

The SQL descriptor area (SQLDA)

SQL procedures in Embedded SQL

Library functions

Loading the interface library dynamically

Embedded SQL commands

Database examples

SQLDEF.H header file