Re: Re: DSPJOBJS(query on how to include all columns in myspool file)

[Vern Hamberg <vhamberg@xxxxxxxxxxxxxxxxxxxxxxxxx>]

Murali

You now know why there is not an *OUTFILE option - there is no way to put 
the data into single records. Subcategories of information are of variable 
size and counts, e.g., I'm sure. The same thing applies to DSPSBSD and 
DSPSYSVAL

You can still use this output, but you will need to do some fancy 
programming - CPYSPLF to a database file (or use the OVRDBF QPRINT yourfile 
command) to get the information into a file you can read in RPG. Then you 
would need to read it, keeping track of identifying markers (reports 
headings, column headings, etc.) for each kind of information you want, 
manipulate state indicators (variables), etc. You can get it, but it's not 
kindergarten work. There are numerous examples in the QUSRTOOL library - 
look for the use of CPYSPLF and RCVF.

Otherwise, you could find out what APIs exist for the Advanced Job 
Scheduler and call those things. You would have more control of what it is 
you are retrieving, and it's generally easier to manage data output from 
there. You could use multiple files, if necessary, to handle the data. Some 
of the work is similar to handling the spooled output, but, as I said, you 
are in control - you know what you are getting, hence, what to do with it. 
You don't need constantly to check "what part of the report am I in now".

Good luck

Vern

At 02:32 PM 7/17/2003 +0000, you wrote:
> Hi all,
> Taking the option *FULL for Detail is giving print in more than 10000 
> pages which is nt my requirment(THAT TOO ITS NT COLUMN ORIENTED,ITS SOME 
> THING LIKE HARRY POTTER BOOK).I NEED COLUMN ORIENTED PRINT_REPORT..Iam 
> getting the following print when i execute the command with Details as 
> *BASIC............