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 a composite index and how does it differ from a multiple index?
What is cursor?
When do you specify the isolation level?
SI Stud name Subject Marks Pass/Fail 1 Sham Maths 40 P 1 Sham Physics 50 P 1 Sham Bio 20 F 2 Ram Maths 40 P 2 Ram Physics 50 P 2 Ram Bio 60 P For the above data , write the SQL query for the student who passed in all the subjects . For eg : I want the data of only Ram coz he passed all subjects .
Mention the definition of cobol in varchar field.
Write a query to retrive partial string.
Can there be more than one cursor open for any program?
Is it possible using max on a char column?
how to get duplicate records from tables?write qurey for this?
What is db2 connect?
What will the FREE command do to a plan?
Following a db2 update statement, what is the quickest way to compute the total number of updated rows?