JCL to get the record count of a table

[Anuj Dhawan]

Thanks dbZ and DikDude it is working fine now.

Glad to hear that but your last response is preety much like:

but the output is not proper in my SYSREC00.

Do NOT post "it didn't work" - which is a complete waste of everyone's time.

What does it do now? Why is this not "proper". What do you want if not the output of the SELECT COUNT?

So now, how did it work, what changes did you make? In short, please share your final solution, if possible.

[archup20]

//STEP010 EXEC PGM=IKJEFT01
//STEPLIB DD DSN=DB2P.RUNLIB.LOAD,DISP=SHR
//SYSTSPRT DD SYSOUT=*
//SYSTSIN DD *
DSN SYSTEM(GRT1)
RUN PROGRAM(DSNTEP2) PLAN(DSNTEP2) -
LIB('DB2P.RUNLIB.LOAD')
END
//SYSREC DD SYSOUT=*
//SYSUDUMP DD SYSOUT=*
//*
//SYSPUNCH DD DUMMY
//SYSPRINT DD DSN=T6329EG.DATA.PUSDSMX,
// DISP=(NEW,CATLG,DELETE),
// SPACE=()
//SYSIN DD *
SELECT COUNT(*)
FROM ODDCDB2P.P.PUSDSMX ;
/*

This is my working code

[DikDude]

Good to hear you have what you need - thank you for the followup and posting your solution

d