1.

How To Execute The Sql Through Jcl Using Utility

Answer»

Answer : //CREATE EXEC PGM=IKJEFT01,DYNAMNBR=20 //SYSTSPRT DD SYSOUT=* //SYSPRINT DD SYSOUT=* //SYSTSIN DD * DSN SYSTEM(DB2T) RUN PROGRAM(DSNTEP2) PLAN(DSNTEP2) LIB('DB2T.RUNLIB.LOAD') END /* //SYSIN DD * SELECT COUNT(USER_UPDATED) FROM CGDEV4.TWC39 WHERE USER_UPDATED='DPPLSPP' GROUP BY USER_UPDATED /*



Discussion

No Comment Found