Method 1: Non-query Statements Without Parameters (Embedded SQL Guide)

Go Up to DSQL Programming Methods (Embedded SQL Guide)

There are two ways to process a SQL statement string containing a non-query statement without placeholder parameters:

• Use EXECUTE IMMEDIATE to prepare and execute the string a single time.
• Use PREPARE to parse the statement for execution and assign it a name, then use EXECUTE to carry out the statement’s actions as many times as required in an application.

Topics

• Using EXECUTE IMMEDIATE
• Using PREPARE and EXECUTE