How would you print the output of an SQL statement from
SPUFI?
Answer Posted / sarath
When you are going to enter into the SPUFI, you need to
specify the output dataset. Then only you can enter into
spufi else you can't enter. so if you want to print the
output then print that output dataset.
Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
Cursors can be declared in both working-storage & procedure division, agreed. But is there any difference? If could you please suggest what is the difference
How can you count the number of rows from a table tab?
How do you eliminate duplicate values in db2?
What is concurrency?
Discuss about db2 bind?
What is the result of open cursor statement?
How do I optimize a query in db2?
Explain about mirror activator disk mirroring?
How do you concatenate the firstname and lastname from emp table to give a complete name?
What is db2 command?
Hi Everyone... Under the Logical files, when am working on multiple rec format logical file, I have joined two pf's using the multiple record format logical file concept, but when i run queried the LF only the first mentioned pf records are reflecting and I am not able to see any of the field records specified under the second pf. Kindly let me know whats the reason behind this. Below is the str of LF., R rec PFILE(LOGICAA) CUSTNO CUSTNAME BILL K CUSTNO R rec1 PFILE(LOGICAA1) CUSTNO ADD K CUSTNO .....
How can you validate Sql errors during cursor operation in db2 pgms and where do you code?
How to compare data between two tables in db2?
What is the function of logging in the db2 database?
Explain about dbrm.