| |
Home |
![[Table of Contents]](/dwicons/b_toc.gif)
|
ASA Programming Interfaces Guide |
![[-]](/dwicons/i_colpse.gif)
| Chapter 2: The Embedded SQL Interface |
Chapter 2
This chapter describes the Embedded SQL programming interface to Adaptive Server Anywhere.
|
| Application development using Embedded SQL |
| Supported compilers |
| Development process overview |
| Running the SQL preprocessor |
| Embedded SQL header files |
| Import libraries |
| A simple example |
| Structure of Embedded SQL programs |
| Loading the interface library dynamically |
| Building NetWare Loadable Modules |
| Embedded SQL data types |
|
| Using host variables |
| Declaring host variables |
| C host variable types |
| Host variable usage |
![[+]](/dwicons/i_expand.gif)
| Indicator variables |
|
| The SQL Communication Area |
| Fields in the SQLCA |
| SQLCA management for multi-threaded or reentrant code |
|
| Using multiple SQLCAs |
|
| Fetching data |
| Embedded SELECT |
| Cursors in Embedded SQL |
| Fetching more than one row at a time |
|
| Static and dynamic SQL |
| Static SQL statements |
| Dynamic SQL statements |
| Dynamic SELECT statement |
|
| The SQL descriptor area (SQLDA) |
| The SQLDA header file |
| SQLDA fields and their meanings |
| Host variable descriptions in the SQLDA |
| Length field values |
|
| Using stored procedures in Embedded SQL |
| Simple procedures |
| Procedures with result sets |
|
| Library functions |
|
| Interface initialization functions |
|
| Connection and server management functions |
|
| SQLDA management functions |
|
| Backup functions |
|
| Request management functions |
|
| Other functions |
| Embedded SQL commands |
|
| Database examples |
| Building the examples |
| Running the example programs |
| Static cursor example |
| Dynamic cursor example |
| Windows NT Service examples |
|
|