Interactive invocation of SQL statements

An SQL statement submitted to Db2 from a terminal is said to be issued interactively.

IBM® relational database management systems allow you to enter SQL statements from a terminal or terminal emulator on a workstation. Db2 for z/OS® provides SPUFI to prepare and execute SQL statements. Workstation-based developer and administrator tools are also available with this capability, such as Db2 Developer Extension.

A statement entered in this way is said to be issued interactively.

A statement issued interactively must not contain parameter markers or references to host variables, because these make sense only in the context of an application program. For the same reason, there is no SQLCA involved.