what is SPUFI ?
Answers were Sorted based on User's Feedback
Answer / naveen87ginjupalli
SPUFI-SQL Processing Using File Input
spufi is used to executes the SQL quries.
By using spufi we can execute more than one Query at a time
and also we can take the backup.
| Is This Answer Correct ? | 6 Yes | 1 No |
Answer / girish kumar
Naveen ans is correct and by using SPUFI we can find the
error code in case of query failure situation.
but it is not posssible in qmf.
| Is This Answer Correct ? | 5 Yes | 0 No |
Can you access the DB2 Directory table using SQL?
What is bind and rebind in db2?
how to unload different table data into different gdg files/ vsam files.
What is meant by isolation level?
OUTER JOINS USED TO GET MATCHING AND NONMATCHING ROWS FORM 2 OR MORE TABLES BASED ON COLUMNS. SIMPLE JOINS ALSO DO THE SAME THEN WHAT IS THE USE OF OUTER JOINS.
What are the benefits of using the db2 database?
Can we use select query in a loop to fetch multiple rows in a COBOL PROGRAM? If so, what is the advantage of cursor?
What is IMAGECOPY ?
Give some example of statistics collected during RUNSTATS?
How do I copy a table in db2?
What can the SET option of the Repair Utility accomplish?
How do you simulate the EXPLAIN of an embedded SQL statement in SPUFI/QMF? Give an example with a host variable in WHERE clause)