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 |
What are the 2 sqlcodes that are returned?
This was related to -811 sqlcode, In a COBOL DB2 program which accesses employee table and selects rows for employee 'A', it should perform a paragraph s001-x if employee 'A' is present. In this case it gets -811 sqlcode, but still it process the paragraph s001-x. What could be wrong in my code.
Can you tell me how can you find out the # of rows updated after an update statement?
When is the skeleton cursor table created?
What is db2 connect?
Describe what a storage group(STOGROUP) is?
What do you mean by cursor?
Could anyone clearly explain the diference between sub query and correlated sub query?
What is a DB2 bind?
What is a buffer in memory?
What is dpf in db2?
How to find the maximum value in a column in the db2 database?