DB2 Count in JCL

[rtyagi1]

i'm trying to write a simple JCL. step one has a query that does a count. I want to check for that count value in my JCL. if the count is > x, i want to set a particular return code. THen, depending on what that return code is, i want to execute setp20. how can i get that done? How can i read my count value so that it can be used in my if statement. thanks!

[dbzTHEdinosauer]

could use a sort product to interrogate the value and issue a return code,
which could be used in a COND parm on step 20 - or the IF.

it may be that you need 2 sort steps. one to read the code (include)
which would either output 1 record or none.

second sort step would input the output file of the first sort step,
and based on record count,
issue the appropriate returncode.