Re: SQL Query of spool file data

On Wed, Apr 22, 2015 at 5:35 PM, Gary Thompson <gthompson@xxxxxxxxxxx> wrote:

Actually, after responding to Rob's post that I was >not< interested in querying spool file data,
I thought of a reason I would want to do that: print sections of a compile listing - but I'm pretty
obsessive in my use of compile listings . . .

OK, that's at least better-suited to getting from a spooled file than,
say, sales data (which you should get from database tables rather than
scraping reports) or a list of active jobs (which most folks recommend
getting from the appropriate API rather than scraping WRKACTJOB
spooled output).

But before you go scraping compile listings, you need to first check
out the compile options. You can turn off various sections of the
listing, and that might be enough to get what you want.

If, after investigating all the compile options, you still feel
strongly that further customization of compile output is worth a bit
of parsing, then by all means, have at it. :) (And that's when I'd
make my pitch for doing it in Python. ;)

John Y.