How SQL statements are invoked

SQL statements are invoked in different ways depending on whether the statement is an executable or nonexecutable statement or the select-statement.

The SQL statements are classified as executable or nonexecutable. The description of each statement includes a heading on invocation that indicates whether or not the statement is executable.

Executable statements can be invoked in the following ways:

• Dynamically prepared and executed in an application program
• Issued interactively

A nonexecutable statement can only be embedded in an application program.