DSQL Programming Methods (Embedded SQL Guide)

Go Up to Using Dynamic SQL

There are four possible DSQL programming methods for handling a SQL statement string. The best method for processing a string depends on the type of SQL statement in the string, and whether or not it contains placeholders for parameters. The following decision table explains how to determine the appropriate processing method for a given string.

SQL statement strings and recommended processing methods

Is it a query?	Does it have placeholders?	Processing method to use
No	No	Method 1
No	Yes	Method 2
Yes	No	Method 3
Yes	Yes	Method 4

Topics

• Method 1: Non-query Statements Without Parameters
• Method 2: Non-query Statements with Parameters
• Method 3: Query Statements Without Parameters
• Method 4: Query Statements with Parameters

Advance To:

• Method 1: Non-query Statements Without Parameters