SPUFI (SQL Processor Using File Input) is a database facility invented by IBM for interfacing with their Db2 system. It is accessed from within TSO ISPF from the DB2I Primary Option menu. SPUFI allows direct input of SQL commands in the TSO environment, rather than having them embedded within a program.

SPUFI reads SQL statements contained as text in a sequential file or in a member of a PDS, processes those statements and places the results in an ISPF browse session. By specifying the input and output data sets and selecting the appropriate options, we can execute SQL statements in an online mode.

When you use SPUFI, you can specify the action that SPUFI is to take when a warning occurs. Output from SPUFI SPUFI formats and displays the output data set using the ISPF Browse program.

SPUFI reads SQL statements contained as text in a sequential file or in a member of a PDS, processes those statements and places the results in an ISPF browse session. By specifying the input and output data sets and selecting the appropriate options, we can execute SQL statements in an online mode. The SPUFI Panel is as follows.

If multiple SQL conditions occur, SPUFI returns the error SQLCODE first, followed by any previous SQLCODE conditions that occurred as the input SQL statement was executed. If the final SQLCODE is an error, most prior SQLCODE warnings can be ignored.

Dec 1, 2020 · Both QMF and SPUFI are tools built to access DB2 databases in a mainframe environment. Using these tools, we can SELECT, UPDATE and DELETE the data from the DB2 database. QMF stands for Query Management Facility and SPUFI stands for SQL Processor Using File Input.

Apr 13, 2006 · SPUFI was meant to be used as an interactive utility. With tedious work (Allocating files, filling ISPF variables, finding the executables etc.) it might be possible to invoke it in batch, but I don't think it worth the effort. You can write your own REXX (to be run in foregroung), using DSNREXX interface. O.

Jul 3, 1996 · In this lesson, you learned how to complete the following tasks interactively in SPUFI: Just as you can query data in Db2 tables and to create database objects by issuing SQL statements in SPUFI, you can also insert, update, and delete data in Db2 tables.

Using SPUFI and IBM Data Studio to Access Db2 Db2 provides tools to execute SQL statements on Db2 database and resources. IBM Data Studio is the most common, and can be used with Db2 on all platforms. SPUFI is used on z/OS. After completing this module, you should be able to: Use SPUR to Run SQL • Use IBM Data Studio to Run SQL 2 26

Jun 16, 2009 · how we continue the query in next line in spufi ? SPUFI uses columns 1 to 72 of the input data set, when you get to column 72 just continue on the next line. There is no continuation indicator!