Re: SQL Query of spool file data

On 22-Apr-2015 12:29 -0500, Gary Thompson wrote:

Anyone know if there is a way to query spool file data ?
<<SNIP>> 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

I am not aware of something specific [to the retrieval of data\attributes about spooled files as database row-data] that has been supplied already by the OS DB\SQL features; like those typically discussed originally on the IBM developerWorks site. But I recall several articles over the years that include code and discuss coding to the spool file listing APIs in order to achieve better selection than what the WRKSPLF provides; no specific recollection of any returning the information as database record-data.

Yet given there are long-existing APIs enabling retrieval of information about spooled files, there is the ability already to create programs that can be described as interfaces to the SQL as external routines; i.e. CREATE FUNCTION [and\or less likely CREATE PROCEDURE to return a result-set] can name the [service] program that would provide the data to the SQL. That is to suggest, instead of waiting for something to be created [and for example delivered in some future TR] to enable querying of the information about SPLF, that instead could be coded [as RYO].

A web search of the API name QUSLSPL and both "CREATE FUNCTION" and "RETURNS TABLE" yielded, for example:
<http://www.mcpressonline.com/programming/rpg/cool-things-sql-functions-and-list-apis.html>
->Programming->RPG->Cool Things: SQL Functions and List APIs
Written by Mike Faust
Friday, 02 September 2011 00:00

And a search of the Open List Of Spooled Files (QGYOLSPL) API instead, though I did not review the contents per it being a PDF, yielded:
<http://www.omniuser.org/downloads/Accessing_Non_Relational_Data_with_SQL.pdf>