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


Please Help Members By Posting Answers For Below Questions

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

969


How can you count the number of rows from a table tab?

833


How do you eliminate duplicate values in db2?

892


What is concurrency?

902


Discuss about db2 bind?

859


What is the result of open cursor statement?

817


How do I optimize a query in db2?

817


Explain about mirror activator disk mirroring?

753


How do you concatenate the firstname and lastname from emp table to give a complete name?

797


What is db2 command?

768


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 .....

2100


How can you validate Sql errors during cursor operation in db2 pgms and where do you code?

1952


How to compare data between two tables in db2?

837


What is the function of logging in the db2 database?

855


Explain about dbrm.

776