Dynamic SQL
Dynamic SQL compiles and executes SQL queries at run time.
The following statements are supported in the Ingres Star:
Note: You must embed these statements in an application program; you cannot use them interactively.
• declare
• prepare
Readies a dynamically constructed command string for later execution.
• describe
Retrieves type, length, and name information about a prepared select statement.
• execute
Executes a previously prepared dynamic SQL statement.