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 |
I want to fetch the 10th row of a table which has been changed.How can I do it without going thru all the rows.
1. what if null values retrived from database and no null indicator mentioned in query. What is sql code.
Differentiate between cs and rr isolation levels? Where do you specify them?
Is DECLARE TABLE in DCLGEN necessary? Why it used?
How can you display the current date & current time ?
What is bufferpool in db2?
What if we fail to give values in columns declared as NOT NULL ?
What is reorg?
For Read Stability locks are not applicable for phantoms, What is Phantoms?
run jcl for cobol+db2 pgm?.. //jobcard //step001 exec pgm=ikjeft01 //systin dd * DSNSYSTEM(--------) RUN PROGRAM(MYPGMNAME) PLAN(-----), LIB(-------), PARMS(------) /* WHAT WILL U GIVE INSIDE THE BRACKETS... WHAT IS PLAN,PACKAGE,BIND?..PLAN N PACAKGES ARE GENERATED BY ?...
What Utility is used to migrate DB2 from one release to the next?
What is the SQL Communications Area and what are some of its key fields?