How can we execute the Teradata BTEQ script?

virupakshagm · Post by **virupakshagm** » Wed Dec 17, 2008 6:04 am

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.

ray.wurlod · Post by **ray.wurlod** » Wed Dec 17, 2008 3:39 pm

Have you tried?

virupakshagm · Post by **virupakshagm** » Thu Dec 18, 2008 12:05 am

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

hamzaqk · Post by **hamzaqk** » Fri Dec 19, 2008 7:09 am

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