How would you print the output of an SQL statement from
SPUFI?
Answers were Sorted based on User's Feedback
Answer / mehdee
- The above answer is right, but before print check your
output file and see how many bytes of the Record length
being 4092 you need to have, then use FILEAID and copy your
output into a file with the record length you need and the
Record format = FB, then print this new file.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / 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 |
Suppose the outcome of executing a query results in a row having null. Based on the answer how you use it? Its declaration and inclusion?
Why PS file called Physical seqential file?How to sore data in sequential file and ESDS file? What is the use of DBRM,PLAN,package and Collection.
How is a typical db2 batch pgm executed?
how do we solve soc 7 and soc4 ?
What are the Isolation levels possible ?
Give some example of statistics collected during RUNSTATS?
Why do we use cursor?
What is schema in db2?
when we are trying to update db2 rows. if the program abends . how we will know that the last successful update row was
Lot of updates have been done on a table due to which indexes have gone haywire. What do you do?
What is innodb buffer pool?
how to copy the host variables from ps file into cobol program other than include statement