Topic
  • 2 replies
  • Latest Post - ‏2013-10-14T12:55:17Z by Ajay Kulkarni
Ajay Kulkarni
Ajay Kulkarni
19 Posts

Pinned topic Functions and Procedures

‏2013-10-13T23:34:39Z |

Hello, For the routines in QSYS2, how would we come to know what is the input and output?

Example, QSYS2.JOBSUMMARY - What is the input and what is the output? I was not able to find the example of of this procedure?

Regards

AJAY

  • B.Hauser
    B.Hauser
    264 Posts

    Re: Functions and Procedures

    ‏2013-10-14T05:20:48Z  

    1. For UDFs and UDTFs all parameters are inupt only

    2. For Procedures, just check IBM i Navigaor --> Position on the procedure --> Right click --> Definition

    JOBSUMMARY has 2 input parameters (MSCHEMA1, MNAME1)

    Birgitta

  • Ajay Kulkarni
    Ajay Kulkarni
    19 Posts

    Re: Functions and Procedures

    ‏2013-10-14T12:55:17Z  
    • B.Hauser
    • ‏2013-10-14T05:20:48Z

    1. For UDFs and UDTFs all parameters are inupt only

    2. For Procedures, just check IBM i Navigaor --> Position on the procedure --> Right click --> Definition

    JOBSUMMARY has 2 input parameters (MSCHEMA1, MNAME1)

    Birgitta

    Thanks Birgitta, What is the purpose of JOBSUMMARY?

    Like when i do a Call jobsummary('AJLIB','MYTABLE'); i don't get anything. I tried to query MYTABLE but no success. I was not able to find the explanation for JOBSUMMARY online