h dftactgrp(*no) h option(*nodebugio) d Exc_Cmd PR extpgm('QCMDEXC') d command 2000A const d length 15P 5 const d DataDS ds d $count 9s 0 d $libList 2750a d $jobd s 10a d $cmd s 2000a d $quote s 1a inz(X'7D') d $errmsg s 100a c *entry plist c parm $jobd /free //Set SQL options exec sql SET OPTION commit=*none, datfmt=*iso; //Get Library List Info exec sql Select LIBL_COUNT, LIBL into :DataDS FROM QSYS2.JOB_DESCRIPTION_INFO WHERE JOBD = :$jobd fetch first 1 rows only; if sqlcod = 0; else; $errmsg = 'Jobd ' + %trim($jobd) + ' not found.'; $cmd = 'SNDMSG MSG(' + $quote + %trim($errmsg) + $quote + ') TOUSR(*REQUESTER)'; Exc_Cmd(%trim($cmd): %len(%trim($cmd))); *inlr = *on; return; endif; $cmd = 'CHGLIBL LIBL(' + %trim($libList) + ')'; Exc_Cmd(%trim($cmd): %len(%trim($cmd))); *inlr = *on; return; /end-free
All one can think and do in a short time is to think what one already knows and to do as one has always done!
Set Library List using JOB Description
You can take advantage of the JOB_DESCRIPTION_INFO view that returns information about job descriptions. The values returned for the columns in the view are closely related to the values returned by the Display Job Description (DSPJOBD) CL command and the Retrieve Job Description Information (QWDRJOBD) API.
No comments:
Post a Comment
NO JUNK, Please try to keep this clean and related to the topic at hand.
Comments are for users to ask questions, collaborate or improve on existing.