Previous Topic Next topic Print topic


Dynamic SQL Statement Types

There are four types of dynamic SQL statement:

Dynamic SQL Statement Type Perform Queries? Return Data?
Execute a statement once No No, can only return success or failure
Execute a statement more than once No No, can only return success or failure
Select a given list of data with a given set of selection criteria Yes Yes
Select any amount of data with any selection criteria Yes Yes

These types of dynamic SQL statement are described more fully below.

Previous Topic Next topic Print topic