DSXchange

Hi,

We have a Teradata BTEQ script, working fine in windows Environment,
I want execute the same through Datastage. Please any body suggest me...

Can we execute this script from Before and after Sql in Teradata stages.....

Thanks in Advance.

Have you tried?

Yes Ray, I tried in different ways like, i wrote the BTEQ script in
Custom SQL
Before SQL
After SQL
Using API and MULTILOAD stages

Also i tried Before and After Job subroutine with ExceDOS in the job properties.
But nothing is worked out

Thanks
Viru

write a shell script and in that call the BTEQ. or use a command stage to call the BTEQ