Programming Languages on Power

Power Programming Languages

IBM Power, including the AIX, IBM i, and Linux operating systems, support a wide range of programming languages, catering to both traditional enterprise applications and modern development needs.


#Power


#Servers
#Programminglanguages
 View Only

  • 1.  What is PROGRAM_STATISTICS used for?

    Posted 03/28/23 09:26 AM
    Edited by Robert Cozzi 03/28/23 09:34 AM

    I attempted to run the PROGRAM_STATISTICS UDTF and consistently get an empty resultSet. 

    What is this UDTF supposed to return?

    Thanks

    ------------------------------
    Robert Cozzi
    ------------------------------


    #SQL


  • 2.  RE: What is PROGRAM_STATISTICS used for?

    Posted 03/29/23 08:25 AM
    Edited by Bryan Dietz 03/29/23 11:28 AM

    I used the SCHEMA action in ACS to find QSYS2.PROGRAM_STATISTICS  and look how it was defined.

    I cannot get any data back, some of the fields defined look like QSYS2.PROGRAM_INFO.



    ------------------------------
    Bryan Dietz
    ------------------------------



  • 3.  RE: What is PROGRAM_STATISTICS used for?

    Posted 03/29/23 11:48 AM

    ok so i did a DSPFD for all views in QSYS2 and found that SYSPACKAGESTAT and SYSPROGRAMSTAT use that UDTF in them.



    ------------------------------
    Bryan Dietz
    ------------------------------

    Original Message


  • 4.  RE: What is PROGRAM_STATISTICS used for?

    Posted 03/29/23 02:39 PM

    Is the UDTF being used on programs that contain SQL statements?  As pointed out, the SYSPROGRAMSTAT catalog view uses this UDTF.



    ------------------------------
    Kent Milligan
    ------------------------------

    Original Message