× 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.



Rob,

Thanks for the responses! It was more than I was expecting.

I am intrigued by the "as far as DSPS36 and CHGS36... I have published
solutions for topics that do not have a proper IBM i (SQL) Service". I
took a quick look at the link you provided (which I had already
bookmarked previously) and could not find anything S/36-related. So
I'm wondering if I just missed it, or if it's published elsewhere.

In any event, DSPS36 fortunately does have an OUTPUT(*PRINT) option,
so that's relatively easy to scrape. As for programmatically changing
settings, I'd have to see if those "published solutions" have anything
applicable. Left to my own devices, I'd probably resort to writing
fancy macros for the ACS 5250 emulator session. (It remains to be seen
whether *any* automation of CHGS36 is worth it, given how infrequently
I imagine (and hope!) this kind of thing is needed.)

John Y.


On Wed, Apr 19, 2023 at 10:20 AM Rob Berendt
<robertowenberendt@xxxxxxxxx> wrote:

In a discussion about this exact topic with an IBMer I got a reply that:
"Hi Rob... I have been publishing SQL solutions at a fierce pace here:
http://ibm.biz/Db2foriSQLTutor ... as far as DSPS36 and CHGS36... I have
published solutions for topics that do not have a proper IBM i (SQL)
Service"

On Wed, Apr 19, 2023 at 8:45 AM Rob Berendt <robertowenberendt@xxxxxxxxx>
wrote:

I believe this information is stored in
Object Type Library
QS36ENV *S36 #LIBRARY

So it's going to take some sort of API. I would be the only way to get
this via SQL is to roll your own (providing you can even find the API) or
see if Bob Cozzi has one. I know a few people who would pull their hair
out if IBM created new sql services for S/36 environment.
If you cannot find an API you could try job tracing, etc to see what calls
happen while you are in there.
Or you could open a case and see if there are any APIs.
I did not find any at:
https://www.ibm.com/docs/en/i/7.5?topic=interfaces-apis-by-category

On Tue, Apr 18, 2023 at 5:55 PM John Yeung <gallium.arsenide@xxxxxxxxx>
wrote:

Is there a way (preferably via SQL) to programmatically get the
information that is available using DSPS36, or to make changes
programmatically instead of using CHGS36?

In particular, I am interested in an easier way to remap the device IDs.

John Y.

As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:
Replies:

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

This mailing list archive is Copyright 1997-2024 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.