Executing Teradata sql script in Shell file

Connectivity
Enthusiast

Executing Teradata sql script in Shell file

Hi,

I am new to Teradata.

Please help me to know how to execute the simple Teradata script from LINUX shell script.

I created  a shell file Sample.sh and the code inside the shell file is below:

-----------------------

#! /bin/bash

.logon 127.0.0.1/DBC,DBC;

select * from employee where emp_id = $1;

.logoff;

.EXIT;

-----------------------

 I execute the script ./Sample.sh 20 > output.txt ( I am passing the value 20 as emp_id )

By executing the above command, I would like to print the output of the sql query in the file 'output.txt'.

But it is not working.

I am getting the below error:

".logon command not found

.logoff command not found"

Please someone help me on this.

1 REPLY
Enthusiast

Re: Executing Teradata sql script in Shell file

You do not invoke  bteq..... something like this:

bteq <<EOF >> $HOME/abc.dat 2>/&1

your logon 

your report file .....something like : .export report file= $PWD/def.dat

your dml....select.....

.export reset

.logoff

EOF 

Try and let me know.