MVSFORUMS.com

[Martin]

Hi All,

I have 2 problems here. I need to write a sql in run in which I need to :

- Pass the date as a parameter.
- capture the count ( Num of rows fetched) from the SQL and based on the rows I need to FTP the file.

Here's an example.

Select * from table 1
where date = current date

Is it possible to capture the count from the SQL and ste MAXCC based on the count.

Say if the count > 100 set maxcc=8

Please let me know ..

Thanks,
Mt

[Nic Clouston]

What we do is:
In the morning run a job which sets the date for the processing day. This is stored in a file.
Any job for that processing date reads that file to get the date. doesn't matter tehn if it runs before or after midnight.
_________________
Utility and Program control cards are NOT, repeat NOT, JCL.

[kolusu]

Martin,

1. check this link

http://www.mvsforums.com/helpboards/viewtopic.php?t=6626&highlight=date

2. Unload the data and run it thru Idcams/sort to set the return code. Check this forum for examples

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu