Using Dynamic SQL
Go Up to Embedded SQL Guide
This chapter describes how to write dynamic SQL applications, applications that elicit or build SQL statements for execution at run time.
In many database applications, the programmer specifies exactly which SQL statements to execute against a particular database. When the application is compiled, these statements become fixed. In some database applications, it is useful to build and execute statements from text string fragments or from strings elicited from the user at run time. These applications require the capability to create and execute SQL statements dynamically at run time. Dynamic SQL (DSQL) provides this capability. For example, the InterBase isql utility is a DSQL application.