|
From: gthompson@xxxxxxxxxxx
To: midrange-l@xxxxxxxxxxxx
Subject: RE: SQL Query of spool file data
Date: Wed, 22 Apr 2015 18:43:26 +0000
Well, I'm not wanting to query spool file contents for this project.
I do want to identify the existence of particular files within a range of date time, etc.
The project is for EDI 856 ASN and the goal is to validate a new
custom app that is to be used to improve warehouse pallet-build accuracy.
We may want to roll this out to warehouses in several western states
so I'm putting a little more into the test/verify step than is
typical, hence my need to locate spool files that have been created for pallets built for recent customer deliveries.
-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of
rob@xxxxxxxxx
Sent: Wednesday, April 22, 2015 12:03 PM
To: Midrange Systems Technical Discussion
Subject: Re: SQL Query of spool file data
Now that is an interesting question.
What would you expect your input to be?
What results would you expect?
select JobName, JobNumber, JobUser, SpoolName, SpoolNumber, SpoolText From qsys2.RetrieveSpoolInfo( OutputQueue :
OutputQueueLib :
SpoolUser :
JobName :
...
)
where SpoolText contains "$2,097.65";
Not that it's near close enough, but the closest I can see is:
http://www-01.ibm.com/support/knowledgecenter/ssw_ibm_i_72/rzajq/rzajq
udfgetjobinfo.htm?lang=en-us
Think of how you could adapt API's from here:
http://www-01.ibm.com/support/knowledgecenter/ssw_ibm_i_72/apis/print1
b.htm?lang=en-us
into SQL.
Then it's just a matter of creating a view or UDTF that will do that for you.
Actually this list is being monitored by IBMers hungry to generate such SQL enhancements...
Helps if you go through the trouble of
https://www-912.ibm.com/r_dir/ReqDesChange.nsf/Request_for_Design_Chan
ge?OpenForm
Rob Berendt
--
IBM Certified System Administrator - IBM i 6.1 Group Dekko Dept 1600
Mail to: 2505 Dekko Drive Garrett, IN 46738 Ship to: Dock 108 6928N
400E Kendallville, IN 46755 http://www.dekko.com
From: Gary Thompson
To: Midrange Systems Technical Discussion
Date: 04/22/2015 01:44 PM
Subject: SQL Query of spool file data
Sent by: "MIDRANGE-L"
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.
--
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.
--
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.
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2025 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact copyright@midrange.com.
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.