Good day all. I happened to run into a developer conversation today about the WRKQRY command that
I found interesting. These guys were trying to figure out if there was a way to kick out all wrkqry's and QM query's
to an outfile and then be able to run a query over the outfile to show the WRKQRY printer device.
I ran this and couldn't find it.
DSPOBJD OBJ(QGPL/ECOPENORDS) OBJTYPE(*QRYDFN *QMQRY) DETAIL(*SERVICE)
OUTPUT(*OUTFILE) OUTFILE(QRYLIB/TESTFILE).
My mind went blank trying to figure it out. Maybe an SQL could pull that info out but I'm not
sure what to run.
I see it if I print out a WRKQRY definition - sample below:
Selected output attributes
Output type . . . . . . . . . . . . . . Printer
Form of output . . . . . . . . . . . . Summary only
Line wrapping . . . . . . . . . . . . . No
Printer Output
Printer device . . . . . . . . . . . . ABCD1234 *---------
Report size
Length . . . . . . . . . . . . . . . 66 (default)
Width . . . . . . . . . . . . . . . . 132
The IBM i community is amongst the smartest group of creative people I know of.
Any idea's to jumpstart my brain would be appreciated.
MM
Respectfully,
Michael Mayer
INFOR Junior LN ERP Administrator
IBM i on Power System Admin
ERMCO-ECI
2225 Industrial Rd
Dyersburg, Tennessee 38024
Cell, Office and Text Messages: 518.641.8906
Email: michael.mayer@xxxxxxxxxxxxx<mailto:michael.mayer@xxxxxxxxxxxxx>
https://www.ermco-eci.com<
https://www.ermco-eci.com/>
https://ermcopower.com/
IBM i Award Winning Blog Site:
https://ibmireference.blogspot.com<
https://ibmireference.blogspot.com/>
Awarded IBM 2024/2025 Advocate, Contributor, Influencer and IBM i Ready Badges.
[cid:image001.jpg@01DC9AAC.27BC0C40]
midrange.com
