Dynamic SQL allows applications to create compiled SQL statements (called “prepared statements”) on the server and execute them at will. The statements can include placeholder variables whose values can be supplied at runtime by application end users. The client application can query the server for the formats of the statement’s input values, if any.
Client-Library fully supports dynamic SQL, providing a call-level interface that implements the ANSI-standard embedded SQL prepare, execute, and execute immediate statements. Client-Library also allows applications to get descriptions of prepared-statement input and output.
Client applications typically use dynamic SQL to allow end users to customize SQL statements at runtime. For example, an application might prepare a SQL query retrieving all known information about a particular customer. This query is prepared as a dynamic SQL statement with a placeholder variable: the customer’s name. At runtime, the application’s end user supplies the customer’s name and executes the prepared statement.
