Schema IQUERY
RTVLASTSPLF( )
The Retrieve Last SPOOLED File ID (RTVLASTSPLF) Function returns
one row that contains information about the most recently created
SPOOLED file for the job that is running the function.
select splfName, job, splnbr from table(iQuery.rtvLastSplf()) splid;
| Column |
Data Type |
Description |
| SPLFNAME |
VARCHAR(10) |
The name of the last SPOOLED File. |
| JOB | VARCHAR(28) | The fully qualified 3-part job name of the
job that produced the SPOOLED file. This should be the same
as the job running the function. |
| JOBNAME |
VARCHAR(10) | The Job Name. |
| JOBUSER |
VARCHAR(10) | The User Profile of the Job that produced the
SPOOLED file. |
| JOBNBR | VARCHAR(6) | The 6-digit job number of the Job that produced the SPOOLED file. |
| SPLNBR |
int |
The SPOOLED File Number. |
| DATE_OPEN |
date | The date the SPOOLED file was opened for
output. |
| TIME_OPEN |
time |
The time the SPOOLED file was opened for
output. |
| ERRMSGID | VARCHAR(7) |
The CPF message ID that occurred when the
QSPRILSP API fails. |