Statements

SQL statements are classified as executable or non-executable.

An executable statement can be invoked in four ways. It can be:

• Issued interactively

• Prepared and executed dynamically

• Embedded in an application program

• Embedded in an SQL procedure, trigger, compound SQL (compiled), or compound SQL (inlined) with some restrictions:

  • Refer to “SQL-procedure-statement” in Compound SQL (compiled) statement for the set of executable statements supported in SQL procedures and compound SQL (compiled) statements.

  • Refer to “SQL-statement” in Compound SQL (inlined) statement for the set of executable statements supported in compound SQL (inlined) statements.

  • Refer to “SQL-procedure-statement” in CREATE TRIGGER statement for the set of executable statements supported in a trigger.