why we go for SPUFI for creating tables or for sql queries?
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
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 |
What is a bind card?
What is the SQL Communications Area and what are some of its key fields?
What is copy pending status in db2?
what is the certification that has a good value for a practioner in mainframes but not habving much knowledge on db2 related stuff?
What do you mean by NOT NULL WITH DEFAULT? When will you use it?
Name some fields from SQLCA
What does the CHECK Utility do ?
What's The Error Code For Unique Index Voilation?
How can you get the number of rows impacted by the last executed query?
Request to database but database is not available so what is was abend is raised?
What are simple, segmented and partitioned table spaces ?
What is image copy in db2?