Re: Easier DSPS36 or CHGS36?

Not that I'm encouraging you to submit any idea about the S/36 environment
but since there are no APIs currently published for S/36 environment and if
you just want to you can submit an idea at https://ideas.ibm.com/

Keep in mind that for spool file scraping
there's SYSTOOLS.SPOOLED_FILE_DATA() at
https://www.ibm.com/support/pages/node/1119123


On Wed, Apr 19, 2023 at 10:42 AM John Yeung <gallium.arsenide@xxxxxxxxx>
wrote:

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.

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

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
questions.