Designing and running a dynamic SQL application

 

To issue a dynamic SQL statement, use the statement with either an EXECUTE statement or an EXECUTE IMMEDIATE statement, because dynamic SQL statements are prepared at run time, not at precompile time.

The EXECUTE IMMEDIATE statement causes the SQL statement to be prepared and run dynamically at program run time.

There are two basic types of dynamic SQL statements: SELECT statements and non-SELECT statements. Non-SELECT statements include such statements as DELETE, INSERT, and UPDATE.

Client/server applications that use interfaces such as Open Database Connectivity (ODBC) typically use dynamic SQL to access the database.

 

Parent topic:

Dynamic SQL applications

 

Related concepts

iSeries Access for Windows: Programming