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 |
What does the sqlcode of -818 pertain to?
What is the physical storage length of time data type?
What is the difference between group by and order by?
Can you search give an array in the WHERE clause of a db2 query?
What is db2 plan table?
Define db2.
AGGREGATE function support by DB2. A) SUM & AVG B) SUM, MIN & AVG C) SUM, MAX, AVG , MIN &COUNT D) NONE
What is meant by union and union all?
What is innodb buffer pool?
What is an alias and how does it differ from a synonym?
When will you chose to run RUNSTATS?
What is role in db2?