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

What is a bind card?

0 Answers  


What is the SQL Communications Area and what are some of its key fields?

1 Answers  


What is copy pending status in db2?

0 Answers  


what is the certification that has a good value for a practioner in mainframes but not habving much knowledge on db2 related stuff?

2 Answers  


What do you mean by NOT NULL WITH DEFAULT? When will you use it?

3 Answers  


Name some fields from SQLCA

1 Answers  


What does the CHECK Utility do ?

1 Answers  


What's The Error Code For Unique Index Voilation?

0 Answers   IBM,


How can you get the number of rows impacted by the last executed query?

1 Answers  


Request to database but database is not available so what is was abend is raised?

2 Answers   UST,


What are simple, segmented and partitioned table spaces ?

1 Answers   TCS,


What is image copy in db2?

0 Answers  


Categories