SPUFI stands for SQL processing using file input. It is the DB2 interactive menu-driven tool used by developers to create database objects.

Read Best Answer

Editorial / Best Answer

Answered by: burelamanohar

• Feb 6th, 2007

---

SPUFI : SQL Processing Using File Input, it supports the on-line execution of SQL statements from a TSO terminal

vineeta bachani

• Oct 17th, 2019

In SPUFI: we can store and write multiple queries but will execute only one at a time. here we mention user-defined input and output datasets
IN QMF: every time we open it we have to write the SQL query again. we dont give input and output datasets

jzmoonrock56

 Profile Answers by jzmoonrock56 Questions by jzmoonrock56

• Aug 31st, 2011

Interactive SQL commands Special Processor Utility File Input

Improve Answer

Table1 has 6 rows and Table2 has 6 SELECT * FROM Table1, Table2; a.6b.12c.36d.720e.Cannot sayrows.36

abhay

• Jul 18th, 2016

The ans is 36, I have tested it.

Devu

• Feb 26th, 2015

36

Answer Question  Select Best Answer

?a.Check if equal to NULLb.Use null indicator, 0 indicates nullc.Use null indicator, -1 indicates nulld.Use null indicator, -2 indicates nulle.None of the above.Use null indicator, -1 indicates null

PRACHI

• Feb 13th, 2015

Place a null indicator variable in front of the host variable for the nullable column in the query, A value of -1 inidcator null value retrieved

Rishu

• Aug 12th, 2014

0:- Not Null
-1:- Null Value
-2:- Null value because of some conversion error

Answer Question  Select Best Answer

A control structure used by DB2 to communicate with the application program isa.Address spaceb.Authidc.Threadd.Viewe.String
Thread

Lalit Pant

• Jul 10th, 2014

The answer is thread. The thread is used by the DB2 to pass the results of the query to the application program.
SQLCA is the set of variables that are used by DB2 to pass the status and error messages of the query execution to the program and are used in error routines and paragraphs.

prachi patankar

• Jun 22nd, 2014

SQLCA

Answer Question  Select Best Answer