How would you print the output of an SQL statement from
SPUFI?
Answer Posted / 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 |
Post New Answer View All Answers
How do I create a view in db2?
What are the full forms of spufi and dclgen and why are they used?
Explain how can you do the explain of a dynamic sql statement?
What is rct?
What is view db2?
What is bind and rebind in db2?
What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?
What do you mean by between and in? Is between inclusive of specified range values?
ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE
i tried to copy some records from microsoft excel to as-400 physical file through "Bosanova" emulation. Out of 14000 records only 12000 records copies and subsequently programe started to hang. Then, i closed the program forcefully. I did' under stand the problem. Also when i try to compile the physical file it is showing as "The file in use". How to overcome this problem?
run jcl for cobol+db2 pgm?.. //jobcard //step001 exec pgm=ikjeft01 //systin dd * DSNSYSTEM(--------) RUN PROGRAM(MYPGMNAME) PLAN(-----), LIB(-------), PARMS(------) /* WHAT WILL U GIVE INSIDE THE BRACKETS... WHAT IS PLAN,PACKAGE,BIND?..PLAN N PACAKGES ARE GENERATED BY ?...
What is reorg and runstats in db2?
Explain package in db2 and its advantages?
How is the value function used?
What is with ur in db2?