× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.

Hi John

I suspect there is not SQL service for config status. I did look at everything on that services page - briefly - and saw nothing that jumped out at me.

WRKCGSTS does have a *PRINT output option, which might be the easiest option now.

There is a regular API for it, QDCLCFGD. Carsten Flensburg has source example at http://www.think400.dk/apier_4.htm#eks0007 - also at https://apimymymy.wordpress.com/2003/06/05/apis-by-example-qrzsche-and-qdclcfgd-apis/

QDCLCFGD has a way to specify you want to see on those things that are varied on. Carsten's example has much more, probably, than you need - you can take the user space processing stuff and adapt to your purposes, after you call the API.

So I suggest you submit an RFE for the future.


On 11/15/2021 8:11 AM, John Rusling via RPG400-L wrote:
Thanks Troy!

Do you have an example or specific link for #1?
In my browser (Firefox & Chrome), it goes to the generic "IBM I Services" page and I don't know which heading to look under or exactly what I'm looking for.

The #2 goes straight to the "OUTPUT_QUEUE_INFO view" page
and gives example "SELECT * FROM QSYS2.OUTPUT_QUEUE_INFO".


Subject: Re: list of devices and list of output queues



density chrysolite

On 11/12/2021 4:01 PM, Greg Wilburn wrote:
Posted this on the midrange forum... only one reply, so I thought I'd try here...

I'm working on two separate projects where I need

1. A list of devices (WRKCFGSTS *DEV) with status (varied on/off)
2. A list of valid output queues

I know there have been quite a few SQL views/functions added to QSYS2, but I can't seem to find either of these. Wondering if there's another way?


As an Amazon Associate we earn from qualifying purchases.

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2023 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.