I would like to get a record count of a file in a CL Program. If "Processed 'N' = 0, I want to skip processing. If Processed 'N' > 0 then continue processing.
I am a bit familiar with RUNSQL to execute SQL statements, but not sure how to get the result into the CL to check the result.
Any suggestions ?
Edit: I could create a logical file, where Processed *NE 'N' then use RCVF and MONMSG CPF0864. Would that work if 0 records in the LF ?
I am a bit familiar with RUNSQL to execute SQL statements, but not sure how to get the result into the CL to check the result.
Any suggestions ?
Edit: I could create a logical file, where Processed *NE 'N' then use RCVF and MONMSG CPF0864. Would that work if 0 records in the LF ?
Comment