Connect Direct Query For Date

abhijit.nayak01 · Posted: Mon Jan 07, 2013 1:39 pm

Hi,

Please see the below connect direct cards which I am using. But I got
a requirement to automate it. The requirement is to pull the file
which is created before 2 days. i.e if today is 2013-01-07 then i need to
pull 2013-01-05 file also the date format is CCYY-MM-DD i.e. hypen is used
in between the dates. SUBDATE1 doesn't allows hypen.

abhijit.nayak01 · Posted: Tue Jan 08, 2013 6:37 pm

Hi,

By using the BPXBATCH in previos step I canfetch the file name. But now the question comes how I will put the file name from the output of BPXBATCH to the CD.

Thanks,
Abhijit.

dick scherrer · Posted: Tue Jan 08, 2013 10:00 pm

Hello,

Where is the output from BPXBATCH written now?

Where do you want it on the CD?

abhijit.nayak01 · Posted: Thu Jan 10, 2013 3:23 am

Hi,

I am able to do the CD successfully now. Wrote a shell command script which gave me output .
&IFILE=unix file name with date as per requirement
SIGNOFF
Used the above o/p in STDOUT which I made temp DSN.
Used the same &&temp DSN in next step i.e. CD step.
Fortunately it worked.
Did more analysis on UNIX side as I realised CD has limitations.

But after the above successful steps I realised I could have solved this issue by using SORT also.
Thanks,
Abhijit.

dick scherrer · Posted: Thu Jan 10, 2013 8:33 pm

Good to hear it is working - thank you for letting us know

d