Export QEZJOBLOG Spool Files ?

[MFisher]

Is there a way to dump all the spooled files in QEZJOBLOG to a file, so I can do a string search ?

[B.Hauser]

Why to copy if you can read it directly?
The OUTPUT_QUEUE_ENTRIES Service in QSYS2 returns all entries in Jobqueues.
With the SPOOLED_FILE_DATA Service in SYSTOOLS you can read the content of a spoolfile.
If you put both together, you can directly search through the spool file data:

Select a.Job_Name, Spooled_File_Name, File_Number, Spooled_Data
     from OutPut_Queue_Entries a Cross Join
           Lateral(Select *
                     From Table(SysTools.Spooled_File_Data(
                                   Job_Name => a.Job_Name,
                                   Spooled_File_Name => a.Spooled_File_Name,
                                   Spooled_File_Number => File_Number))) b
    Where     Output_Queue_Name = 'QEZJOBLOG'
          and Spooled_Data like '%WhateverYouWant%';

Birgitta

[MFisher]

Great Solution. Thanks !!

[MFisher]

I am puzzled why I get 0 results from "PURCHASING" which has 37 files , when I want 'P%' OUTQs

 Work with All Output Queues

Type options, press Enter.
2=Change 3=Hold 4=Delete 5=Work with 6=Release 8=Description
9=Work with Writers 14=Clear

Queue      Library Files Writer Status
[COLOR=#e74c3c]PURCHASING[/COLOR] QUSRSYS 37 RLS
[COLOR=#c0392b]P1[/COLOR]         QUSRSYS 169 HLD

But when I run this, I only get results for P1 OUTQ

SELECT *
from QSYS2.OutPut_Queue_Entries a Cross Join
Lateral(Select *
From Table(SysTools.Spooled_File_Data(
Job_Name => a.Job_Name,
Spooled_File_Name => a.Spooled_File_Name,
Spooled_File_Number => File_Number))) b
Where [COLOR=#e74c3c]Output_Queue_Name like 'P%'[/COLOR]
and OUTPUT_QUEUE_LIBRARY_NAME = 'QUSRSYS'
order by Output_Queue_Name

[MFisher]

I should see all the files in PURCHASING, since I am not filtering on content.

I DO get expected results from this:

SELECT * from QSYS2.OutPut_Queue_Entries
where OUTPUT_QUEUE_NAME = 'PURCHASING'
order by user_data