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 are the various locks available?
Which is faster delete or truncate?
What are the three lock types?
what is the role of the cursor in db2?
What is the cobol picture clause of the db2 data types date, time, timestamp?
What does reorg do in db2?
What is database reorganization?
what is the use of cursors?
Can we insert update delete in view?
What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?
4. A DB2 application is bound with uncommitted Read isolation level.It issues a request that retrieves 20 rows out of 200000 in the table. Which of the following descrbes the rows that are locked as a result of this request? a. None of the rows are locked. B.The retrieved rows are locked. C.The last row of the result set is locked. D.The rows not previously updated by another application are locked.
What is db2 catalog database?