Archives of the TeradataForum

Message Posted: Tue, 02 Nov 2004 @ 09:36:23 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Roopali,

you can achieve this in an alternative way by doing some thing like this: ensure that your .SQL file is some thing like this:

BTEQ << EOF
LOGON tdp1/rxdoshi,rh34nr93;
.titledashes off
.os rm outfile
.export file outfile
        call dvd1.p1ts(fp (title ''));
.export reset
.exit
EOF

And in you main shell script you can get the output value to some variable like var1=`cat outfile` and take necessary action based on var1. Hope that solves your problem.

-Naresh

	<Prev	Next>		<<First	<Prev	Next>	Last>>