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 is the significance of DB2 free space and what parameters control it?
What information is contained in a SYSCOPY entry?
db2 query I have one table with the following details. SNO SNAME DOJ ------ -------------------- ---------- 10 KRISH 2007-03-19 20 REDDY 2007-05-19 30 RRRRR 2007-05-19 40 BBBBB 2008-05-19 50 CCCCC 2009-05-19 60 JJJJJ 2009-05-19 70 JJJJJ 2004-05-19 i want the output in the following format:( no of students joined in each year(no nedd to consider about month and date) year count --------- ---------- 2004 1 2007 3 2008 1 2009 2
What are some SQL aggregates and other built-in functions?
What are the functions of Bind?
what is the difference between declaring the cursor in WS section and Procedure division?
What is meant by dclgen?
What is meant by index cardinality?
What is a cursor and what is its function?
What keyword does an SQL SELECT statement use for a string search?
Mention the definition of cobol in varchar field.
How to rename a table in DB2 ?