Re: SQL Query of spool file data

Not cute, true. A spooled file is not data. It's a picture of your data.

If it was data, we wouldn't be having this discussion and we could query it
with SQL, UPDDTA, WRKQRY or even CHAIN to a spooled file.

I know my way around spooled files too. :) Written a few apps working
with them.

Brad
www.bvstools.com

On Wed, Apr 22, 2015 at 4:30 PM, John Yeung <gallium.arsenide@xxxxxxxxx>
wrote:

On Wed, Apr 22, 2015 at 4:41 PM, Bradley Stone <bvstone@xxxxxxxxx> wrote:

Searching spooled files for "data" is like trying to find your real

brother

(in the flesh) in a family picture. :)

Cute, but for most IT purposes, a recent-enough snapshot of data and
"the real, live data" are close enough that you could do with either.
In particular, they are both usually close enough to the same *type*
of object, and more-or-less convertible from one to the other. (That
is, the snapshot of an integer is either the same as or just as good
as an "actual" integer. But a picture of your brother cannot help you
move furniture.)

If possible, you'd be better off querying the actual data that was used

to

create the spooled file if possible.

This is definitely true. But, as was later revealed, OP's use case
actually doesn't involve searching the contents of spooled files, but
rather the metadata (specifically, creation date).

John Y.
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.