WebOct 30, 2024 · I can just run the following statement and have the total number of spool files and total size returned to me: 01 SELECT COUNT (*) AS "Total splf", 02 SUM (SIZE) AS "Total size" 03 FROM QSYS2.OUTPUT_QUEUE_ENTRIES. Line 1: The COUNT, as you would assume, gives the count of rows (= spool files) in the View. Line 2: SUM totals the size column for ... WebOct 21, 2024 · I would like to know if anyone has had success reading iSeries Navigator Spool files (text reports) directly from Navigator. I know there are ways to download or ftp such reports, but I would like to avoid moving these reports, since they are frequently refreshed under the same file names.
[SOLVED] iSeries printer configuration - - IBM Hardware
WebMar 10, 2015 · For simply inserting data the fastest way is going to use an AS400 command and flat copy the data into the file. The fastest insert with sql is going to be a multiple insert. Either method when you *DLY index maintenance … WebWhen you finish the necessary setup tasks, you are ready to back up Windows server files on OS/400. To be able to restore a directory or file by share name, you must specify that file … harlots actors
Output queue entries information via SQL @ RPGPGM.COM
WebDec 9, 2015 · OUTQ_DTL, OUTQ_INFO. I have 2 SQL's written in ACS that look like this. Modify as needed.-- Output Queue Info SQL. -- Spooled files by library / output queue. Select * from qsys2.outq_info--- Where Output_priority <> 5--- Where ... there are multiple selections that can be made here. Bring up SQL for field names or use DSPFFD qsys2/outq_info. WebOct 31, 1990 · If you converted to the AS/400 from the System/36, you probably gave only a passing thought to job and output queues. After all, on the System/36 these things are pretty simple. Put jobs on the job queue, get printouts from the output queue. WebJun 23, 2024 · The OUTQ attribute has two special values, *JOB, and *DEV. *JOB is the default, and causes the output queue to be obtained from the job itself. Note that if we use the defaults, the DEV attribute in the printer file is not used. harlots actress