Progress
Embedded SQL-92
Guide and Reference
Introduction
When you write an ESQL application and you place specific SQL statements in your program, these statements are called static SQL statements. For example, an application might produce a daily inventory report, executing the same query every morning. However, in many applications the exact SQL statements are not known at compile time. Part or all of the SQL statements are known only at run time, often from user input provided to the application. Such SQL statements are called dynamic SQL statements. For example, the SQL statements you address to the SQL Explorer tool are ad hoc statements. They might be, for example, SELECT or INSERT. These statements are processed by SQL Explorer as dynamic SQL statements. Dynamic SQL statements provide more flexibility in what they can accomplish, but the run-time cost is usually higher.
These are the general steps to follow when you execute a dynamic statement that is a SELECT statement:
These are the general steps to follow when you execute a dynamic statement that is a non-SELECT statement:
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |