Re: SQL Query of spool file data

[Bradley Stone <bvstone@xxxxxxxxx>]

Searching spooled files for "data" is like trying to find your real brother
(in the flesh) in a family picture.  :)

If it's a one time thing, you could use our SPLTOOL software to convert
them to txt (all at once) and search that way.  But either way it won't be
pretty.

A spooled file is not meant to be "data".  It is a snapshot of your data.

If possible, you'd be better off querying the actual data that was used to
create the spooled file if possible.

Brad
www.bvstools.com

On Wed, Apr 22, 2015 at 2:53 PM, Richard Schoen <
Richard.Schoen@xxxxxxxxxxxxxxx> wrote:

> The answer is Yes, however a little more clarity on the business
> requirements would be good.
>
> You can post here or feel free to reach out to me directly below if you
> want to talk about potential commercial options.
>
> Regards,
>
> Richard Schoen | Director of Document Management Technologies, HelpSystems
> T: + 1 952-486-6802
> RJS Software Systems | A Division of HelpSystems
> richard.schoen@xxxxxxxxxxxxxxx
> www.rjssoftware.com
> Visit me on: Twitter | LinkedIn
> ------------------------------
>
> message: 4
> date: Wed, 22 Apr 2015 17:29:15 +0000
> from: Gary Thompson <gthompson@xxxxxxxxxxx>
> subject: SQL Query of spool file data
>
> Anyone know if there is a way to query spool file data ?
> Recently I've seen posts by persons like Michael Sansoterra at Broadway
> Systems
> showing recently added support for SQL query of iSeries operational data.
> We're a year or so behind on PTF's (sun is setting here), but my current
> project could
> benefit from something more flexible than WRKSPLF
>
>
> --
> 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.