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

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
    250 Posts
    ACCEPTED ANSWER

    Re: Functions and Procedures

    ‏2013-10-14T05:20:48Z  in response to Ajay Kulkarni

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

      Re: Functions and Procedures

      ‏2013-10-14T12:55:17Z  in response to B.Hauser

      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