Calling a bteq Script from informatica

Analytics

Calling a bteq Script from informatica

Hi,
through Informatica session: post session command, I am trying to call a shell script : test.sh which inturn calls a BTEQ script
test1.bteq
I am getting below error :
test.sh[6]: test1bteq: cannot open
Can anybody tell me what I am missing here?

2 REPLIES
Enthusiast

Re: Calling a bteq Script from informatica

Hi,

Instead of calling a shell script and invoking a BTEQ, you can directly invoke a BTEQ script in a command Task immediately after the required session.

Regards,
Balamurugan
Enthusiast

Re: Calling a bteq Script from informatica

Hi Murugan,

Can u pls explain how to invoke a BTEQ script in a command Task after the required session.

Below command is not working...

sh ./opt/teradata/client/13.10/bin/bteq</teradata/ITR4/Bteq_Script.inc

What are the commands we should use to invoke BTEQ directly.

Thanks in advance..