Interactive SQL statements

Interactive SQL refers to SQL statements that you submit to Db2 by using SPUFI (SQL processor using file input), the command line processor, or by using developer tools such as IBM Db2 for z/OS Developer Extension or QMF for Workstation.

You can enter and run SQL statements at a TSO terminal by using the SPUFI (SQL processor using file input) facility. SPUFI prepares and executes these statements dynamically. The easiest and most efficient way to run SQL is to use developer tools from a workstation, such as such as IBM Db2 for z/OS Developer Extension or QMF for Workstation. All of these tools prepare and dynamically execute the SQL statements.

Start of change

IBM Db2 for z/OS Developer Extension for Microsoft Visual Studio Code

IBM Db2 for z/OS Developer Extension for Visual Studio Code (Db2 Developer Extension) is a free downloadable extension that provides SQL language support to a modern and widely adopted IDE. Db2 Developer Extension delivers capabilities that help developers to write syntactically correct Db2 for z/OS SQL quickly. For more information, see Introduction to Db2 for z/OS Developer Extension.

Coupled with IBM Z Open Editor for Visual Studio Code, Db2 Developer Extension delivers a comprehensive set of tools for developing applications that run on the IBM zSystems platform. Both IBM Z Open Editor and Db2 Developer Extension are also supported by the Eclipse Theia IDE platform.

End of change

QMF for Workstation

QMF for Workstation is a query tool that lets you enter and run your SQL statements easily. This topic acquaints you with using QMF for Workstation to create and run SQL statements. QMF for Workstation simplifies access to Db2 from a workstation. In fact, was QMF for Workstation built for Db2.

You can use QMF for WebSphere to enter and run SQL statements from your web browser or useQMF for TSO/CICS to enter and run SQL statements from TSO or CICS®. For more information, see Submitting SQL statements with QMF for Workstation.