• Installed licensed products with options

    From Jonathan Ball@21:1/5 to All on Tue Nov 19 12:58:58 2019
    Is there an IBM-supplied table or view that will yield the installed
    licensed products _with_ options? QSYS2.LICENSE_INFO has the products, but
    not the options.

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Dr.UgoGagliardelli@21:1/5 to All on Wed Nov 20 07:16:37 2019
    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?  QSYS2.LICENSE_INFO has the products,
    but not the options.
    GO LICPGM
    or
    DSPSFWRSC
    or
    WRKLICINF

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Jonathan Ball@21:1/5 to Dr.UgoGagliardelli on Wed Nov 20 19:00:46 2019
    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?  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.

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)