RE: Looking for documentation on API replacements using SQL functions / tables

It has a shortcut url of: http://ibm.biz/DB2foriServices
The site was recently updated to include 7.4. However when they updated that they dropped the 7.1 information which listed what services came out in 7.1 and what DB2 group PTF you needed to have that service. Not that I care, but others might.

You might want to print these off in landscape mode
http://www.ibm.com/developerworks/ibmi/techupdates/db2/landscape

See also
https://www.ibm.com/support/knowledgecenter/ssw_ibm_i_74/rzajq/rzajqkickoff.htm
DB2 for i Services
IBM i Services
SYSTOOLS

https://www.ibm.com/support/knowledgecenter/ssw_ibm_i_74/db2/rbafzcatalog.htm
IBM i catalog tables and views
ODBC and JDBC catalog views
ANS and ISO catalog views

Remember, you can always click on "Change version or product" to select from:
IBM i 7.4
IBM i 7.3
IBM i 7.2
IBM i 7.1

-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Craig Richards
Sent: Monday, April 29, 2019 11:15 AM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxxxxxxxx>
Subject: Re: Looking for documentation on API replacements using SQL functions / tables

https://www.ibm.com/developerworks/community/wikis/home?lang=en#!/wiki/IBM%20i%20Technology%20Updates/page/DB2%20for%20i%20-%20Services




On Mon, 29 Apr 2019 at 16:11, <smith5646midrange@xxxxxxxxx> wrote:

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

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