How SQL statements are invoked

The SQL statements described in this chapter are classified as executable or nonexecutable. The Invocation section in the description of each statement indicates whether the statement is executable.

An executable statement can be invoked in any of the following ways:

  • Embedded in an application program
  • Dynamically prepared and executed
  • Issued interactively
Note: Statements embedded in REXX or processed using RUNSQLSTM are prepared and executed dynamically.

Depending on the statement, some or all of these methods can be used. The Invocation section in the description of each statement tells you which methods can be used.

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