Wish list: 1 - WRKSPLF give the capability to search a users spool files by date. WRKOUTQ does not. It would be nice to have the ability to search an OUTQ by user or date. Also, the sort order. RDY, SAV, HLD is difficult when an OUTQ has 1000’s of entries. 2- Display spool file. With the explosion of Free-form use, searching a spool file by upper-case is not a given. If SEU in “Browse/Copy Options” you have the ability to search ignoring case, why not Browse spool file? Hasn’t i-series in its’ puberty reached a point that this would be possible?
Im not an sql guru, forgot any limited knowledge I had . And being a one man band for a co that needs an orchestra, don't have time to learn it. But thanks anyway
Oh, you'll think we're crazy, but due to regulatory needs of having to have spool files on line for a given period, one of our outqs has 140k files. So u can see why it's difficult navigating
Would it be easier to convert those spool files to, let's say PDFs? That way they can be copied to network, CD or whatever and you could then release that space to be used for something else.
To prevent "comment spam" all comments are moderated. Learn about this website's comments policy here.
Some people have reported that they cannot post a comment using certain computers and browsers. If this is you feel free to use the Contact Form to send me the comment and I will post it for you, please include the title of the post so I know which one to post the comment to.
Wish list:
ReplyDelete1 - WRKSPLF give the capability to search a users spool files by date. WRKOUTQ does not. It would be nice to have the ability to search an OUTQ by user or date. Also, the sort order. RDY, SAV, HLD is difficult when an OUTQ has 1000’s of entries.
2- Display spool file. With the explosion of Free-form use, searching a spool file by upper-case is not a given. If SEU in “Browse/Copy Options” you have the ability to search ignoring case, why not Browse spool file? Hasn’t i-series in its’ puberty reached a point that this would be possible?
I know this is not exactly what you have asked for in number 1 but have you tried using the OUTPUT_QUEUE_ENTRIES View and Table functions?
DeleteIm not an sql guru, forgot any limited knowledge I had . And being a one man band for a co that needs an orchestra, don't have time to learn it. But thanks anyway
ReplyDeleteOh, you'll think we're crazy, but due to regulatory needs of having to have spool files on line for a given period, one of our outqs has 140k files. So u can see why it's difficult navigating
ReplyDeleteWould it be easier to convert those spool files to, let's say PDFs?
DeleteThat way they can be copied to network, CD or whatever and you could then release that space to be used for something else.
that too :)
ReplyDelete