why we go for SPUFI for creating tables or for sql queries?

Answers were Sorted based on User's Feedback



why we go for SPUFI for creating tables or for sql queries?..

Answer / girish kumar

By using SPUFI we can get the error code when the query fails, and at a time we can execute multiple queries.
QMF doesn't support to execute multiple queries at a time.

Is This Answer Correct ?    4 Yes 0 No

why we go for SPUFI for creating tables or for sql queries?..

Answer / vijay krishna

SPUFI is abbreviated as SQL Processing for File Input.
Through SPUFI, you can execute a set of queries one time by
feeding an input file and whereas through QMF, you can
execute only one query at a time.

Is This Answer Correct ?    0 Yes 0 No

why we go for SPUFI for creating tables or for sql queries?..

Answer / satty

becoz spufi is interactive and spontaneous which makes user
to create faster and allows user to know whats wrong when
there is error.

Is This Answer Correct ?    0 Yes 0 No

why we go for SPUFI for creating tables or for sql queries?..

Answer / hemant

see man first of all we need to know full form of sql..it
is structured query language...now why we use sql.this
question arises

Is This Answer Correct ?    1 Yes 2 No

Post New Answer

More DB2 Interview Questions

Bind concepts in DB2 cobol

10 Answers   IBM, TCS, TRD, Virtusa,


What is the connection string to connect to the DB2 Database ?

0 Answers   MCN Solutions,


how can we retrieve the 100 records of the file ?

2 Answers   IBM,


What is cloudant database?

0 Answers  


How many Buffer pools are there in DB2 and what are they?

1 Answers   IBM,






How do I import data from excel to db2?

0 Answers  


Can a Db2 table data be retrived through JCL?

4 Answers  


What is reorg?

0 Answers  


If I have 5 Queries in a DB2 Cobol program , while precompiling how many DBRMs will get created and How many Plans and Packages will get created while Bind Process?

8 Answers   Accenture,


If we keep the DCLGEN structure for a table in a copybook and include it in the COBOL program using the COPY statement, will there be any impact during compilation or at any stage of program execution?

2 Answers  


what is the use of cursors?

3 Answers   iGate,


Why do we use cursor?

0 Answers  


Categories