We are able to identify list of jobs with MAINT N in batch with LJOB,JOB=*,MAINT=N command. How do I produce the same list the jobs using Datacom SQL?
Release : 12.1
Component :
Below is the sample SQL job to list jobs with MAINT = N:
//STEP1 EXEC PGM=DBSQLPR
//STEPLIB DD DISP=SHR,DSN=your.CUSLIB
// DD DISP=SHR,DSN=your.CAAXLOAD
//SYSPRINT DD SYSOUT=*
//STDOUT DD SYSOUT=*
//OPTIONS DD *
PRTWIDTH=255
INPUTWIDTH=70
ROWLIMIT=5000
AUTHID=MFWA
NOTYPE
//SYSIN DD *
SELECT JOB, IGNORE_RQMT FROM CA7_JOB
WHERE DB = 'yourlogicaldb' AND
IGNORE_RQMT = 'N' ;