check char value in OUTFIL
Posted: Tue Sep 28, 2010 4:49 pmhi ,
i am facing a problem in OUTFIL, i am trying to put a query in the output dataset from jcl in the string. i am able to create the dataset with required query but i want to check SF_SUB_ACCT_TYPE = L and it is a char field ,but not able to check .
how can i check for char value while building the string through outfil ?
i am facing a problem in OUTFIL, i am trying to put a query in the output dataset from jcl in the string. i am able to create the dataset with required query but i want to check SF_SUB_ACCT_TYPE = L and it is a char field ,but not able to check .
//SORT009 EXEC PGM=SORT
//SYSOUT DD SYSOUT=*
//SORTIN DD DSN=CS.DH6D.DATE.B2.BATQ110,DISP=SH
//SORTOUT DD DSN=CS.DH6D.DEL.CURDSF,
// DISP=(,CATLG,DELETE),
// DCB=(RECFM=FB,LRECL=100),
// SPACE=(100,(1,1),RLSE),AVGREC=K
//SYSIN DD *
SORT FIELDS=COPY
OUTFIL BUILD=(C'SELECT * FROM DSF_SUB_FACILITY ',
C'WHERE SF_YEAR_MTH = ',
52:53,6,
C' AND SF_SUB_ACCT_TYPE =',C'L',
C'; COMMIT; ',
09C' ')
//SYSOUT DD SYSOUT=*
//SORTIN DD DSN=CS.DH6D.DATE.B2.BATQ110,DISP=SH
//SORTOUT DD DSN=CS.DH6D.DEL.CURDSF,
// DISP=(,CATLG,DELETE),
// DCB=(RECFM=FB,LRECL=100),
// SPACE=(100,(1,1),RLSE),AVGREC=K
//SYSIN DD *
SORT FIELDS=COPY
OUTFIL BUILD=(C'SELECT * FROM DSF_SUB_FACILITY ',
C'WHERE SF_YEAR_MTH = ',
52:53,6,
C' AND SF_SUB_ACCT_TYPE =',C'L',
C'; COMMIT; ',
09C' ')
how can i check for char value while building the string through outfil ?