MVSFORUMS.com

[satyenderd]

Hi all,

Herein I am facing a problem while unloading the data from Production.
I am trying to unload the data quering on 2 tables using the below query in DSNTIAUL utility. Table1 is having around 98726051 rows and Table2 is having 43535826. I used the parameter TIME=1410 also in the job statement. But still I am unable to unload the job, even after 3 hrs.
Could anyone pls help me in this regard.

Thanks in advance.

SELECT *
FROM
table1
WHERE RDNDTE IN
(SELECT RDNDTE
FROM
table2
WHERE DATE(RDNDTE) >= CURRENT DATE - 5 YEARS);
_________________
Satya