The SERVICES_INFO table in the QSYS2 schema includes information (including
examples and the earliest possible release) for all Db2 and IBM i Services.
The documentation for all Db2 and IBM i Services can be found under
Performance and Query Optimization (in the Information Center)
Db2 for i Services -
https://www.ibm.com/support/knowledgecenter/ssw_ibm_i_74/rzajq/rzajqservices
db2.htm
IBM i Services -
https://www.ibm.com/support/knowledgecenter/ssw_ibm_i_74/rzajq/rzajqservices
sys.htm
You will also find a lot of examples within ACS - Run SQL Scripts - Edit -
Insert from Examples
Mit freundlichen Grüßen / Best regards
Birgitta Hauser
"Shoot for the moon, even if you miss, you'll land among the stars." (Les
Brown)
"If you think education is expensive, try ignorance." (Derek Bok)
"What is worse than training your staff and losing them? Not training them
and keeping them!"
?Train people well enough so they can leave, treat them well enough so they
don't want to.? (Richard Branson)
-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of
smith5646midrange@xxxxxxxxx
Sent: Montag, 29. April 2019 17:11
To: 'Midrange Systems Technical Discussion' <midrange-l@xxxxxxxxxxxxxxxxxx>
Subject: Looking for documentation on API replacements using SQL functions /
tables
I recently stumbled over "select * from QSYS2.ASP_INFO" as a way of getting
ASP information. Sooooo much easier than using the QYASPOL API.
Is there somewhere that these API replacement functions are documented and
that hopefully includes what release they showed up in? I'm looking for
some kind of high level function list that I can read through and then drill
down from there if I see something I need.
--
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@xxxxxxxxxxxx for any subscription related questions.
Help support midrange.com by shopping at amazon.com with our affiliate link:
https://amazon.midrange.com
midrange.com
