RE: WRKQRY question ...

Hello Michael,

I have some old RPG code using MI to retrieve query definition statements for security level 30 or below. Let me know if you want a copy.

Cheers,
Carsten

From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Michael Mayer via MIDRANGE-L
Sent: 10. februar 2026 23:47
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxxxxxxxx>
Cc: Michael Mayer <michael.mayer@xxxxxxxxxxxxx>
Subject: WRKQRY question ...

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<mailto:michael.mayer@xxxxxxxxxxxxx%3cmailto:michael.mayer@xxxxxxxxxxxxx>>
https://www.ermco-eci.com<https://www.ermco-eci.com><https://www.ermco-eci.com/<https://www.ermco-eci.com/>>
https://ermcopower.com/<https://ermcopower.com>
IBM i Award Winning Blog Site: https://ibmireference.blogspot.com<https://ibmireference.blogspot.com><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]



--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx<mailto:MIDRANGE-L@xxxxxxxxxxxxxxxxxx>
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l<https://lists.midrange.com/mailman/listinfo/midrange-l>
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx<mailto:MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx>
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l<https://archive.midrange.com/midrange-l>.

Please contact support@xxxxxxxxxxxxxxxxxxxx<mailto:support@xxxxxxxxxxxxxxxxxxxx> for any subscription related questions.

This email was sent on behalf of Awaze Vacation Rentals Ltd
Company Registration Number 00965389
VAT Registration Number GB 598 22 99 77
Registered in England and Wales
Registered Office: Sunway House, Raglan Road, Lowestoft, NR32 2LW

This email is strictly confidential. By opening it, the recipient accepts that Awaze Vacation Rentals Ltd are not liable for any loss or damage arising.