Working with Dynamic SQL

Go Up to API Guide

This chapter describes how to use API dynamic SQL (DSQL) functions to handle dynamically created SQL statements for data definition and manipulation. Using low-level API calls enables client applications to build SQL statements or solicit them from end users at runtime, providing end users with a familiar database interface. It also provides applications developers low-level access to InterBase features, such as multiple databases, not normally available at a higher level with embedded DSQL statements. For example, the InterBase isql utility is a DSQL application built on low-level API calls.

All API DSQL function names begin with “isc_dsql” to make it easier to distinguish them from other API calls.

Topics

• Overview of the DSQL Programming Process
• DSQL API Limitations
• Writing an API Application to Process SQL Statements
• Understanding the XSQLDA
• Change View API Support (API Guide)
• DSQL Programming Methods
• Determining an Unknown Statement Type at Runtime

Advance To:

• Overview of the DSQL Programming Process