Hi,
I am trying to run the below query to just display the jobs in MSGW :
SELECT JOB_NAME,SUBSYSTEM,AUTHORIZATION_NAME, 054 JOB_TYPE,JOB_STATUS,FUNCTION,CPU_TIME 055 FROM TABLE(QSYS2.ACTIVE_JOB_INFO(JOB_NAME_FILTER => '*ALL')) A 056 WHERE JOB_STATUS = 'MSGW' 057 ORDER BY ORDINAL_POSITION ;
However, it throws an error - the keyword 'Table' is not recognized.
Is there a way to get this function executed?
Valence Version: 5.1.20180118.0
Regards,
Pavan
I am trying to run the below query to just display the jobs in MSGW :
SELECT JOB_NAME,SUBSYSTEM,AUTHORIZATION_NAME, 054 JOB_TYPE,JOB_STATUS,FUNCTION,CPU_TIME 055 FROM TABLE(QSYS2.ACTIVE_JOB_INFO(JOB_NAME_FILTER => '*ALL')) A 056 WHERE JOB_STATUS = 'MSGW' 057 ORDER BY ORDINAL_POSITION ;
However, it throws an error - the keyword 'Table' is not recognized.
Is there a way to get this function executed?
Valence Version: 5.1.20180118.0
Regards,
Pavan
Comment