From Newsgroup: comp.sys.ibm.as400.misc
On 11/19/2019 10:16 PM, Dr.UgoGagliardelli wrote:
Il 19.11.2019 21.58, Jonathan Ball ha scritto:
Is there an IBM-supplied table or view that will yield the installed
licensed products _with_ options?-a QSYS2.LICENSE_INFO has the products,
but not the options.
GO LICPGM
or
DSPSFWRSC
or
WRKLICINF
Thanks, but I already knew how to find them using a CL command. What I was interested in was being able to run a SQL query to import them into a spreadsheet.
In the end, I created a table function using an RPGLE service program that calls API QSZSLTPR to retrieve the licensed programs and return them as a result set:
select *
from table(mylib.get_lic_prod ()) p
where installed = 'YES'
The result set has columns for product ID, product option, release level, description, installed, supported and a few other items.
As I said at the top, the IBM view QSYS2.LICENSE_INFO shows the products,
but not the product options.
--- Synchronet 3.21d-Linux NewsLink 1.2