BTEQ RUN FILE Warning message

Tools & Utilities

BTEQ RUN FILE Warning message

I'm trying to use "RUN FILE" command in a BTEQ to call a LOGON script, but I always get a Warning message (*** Warning: EOF on INPUT stream.).

The BTEQ code is simple (teste_conexao_bteq.bteq):

.RUN FILE 'logon_bteq.sh';
.LOGOFF
.QUIT

logon_bteq.sh content:

.LOGON tdmach/USERNAME,PASSWORD;

See below the BTEQ execution:

bteq < teste_conexao_bteq.bteq
BTEQ 08.02.01.00 Thu Jul 13 11:26:59 2006

+---------+---------+---------+---------+---------+---------+---------+----
.RUN FILE 'logon_bteq.sh';
+---------+---------+---------+---------+---------+---------+---------+----
.LOGON tdmach/USERNAME,

*** Logon successfully completed.
*** Transaction Semantics are BTET.
*** Character Set Name is 'ASCII'.

*** Total elapsed time was 10 seconds.

+---------+---------+---------+---------+---------+---------+---------+----
*** Warning: EOF on INPUT stream.
+---------+---------+---------+---------+---------+---------+---------+----
.LOGOFF
*** You are now logged off from the DBC.
+---------+---------+---------+---------+---------+---------+---------+----
.QUIT
*** Exiting BTEQ...
*** RC (return code) = 0

I'm running it in a Sun Solaris and I already tried to save file in UNIX and in DOS format.

Anyone knows what's going on?

4 REPLIES
Teradata Employee

Re: BTEQ RUN FILE Warning message

Perhaps the wording could be better, but it's just an informational message that tells you BTEQ has exhausted the .RUN file and is going to resume reading commands from stdin. You can ignore the "Warning".

Re: BTEQ RUN FILE Warning message

can any one help me to know how we can avoid this message
Enthusiast

Re: BTEQ RUN FILE Warning message

if you are so particular about it, then this is the way ...

(

cat loginFile
cat MySQLsFile
echo ".QUIT;"
) | bteq
Enthusiast

Re: BTEQ RUN FILE Warning message

BTEQ returns this warning message if your RUN file does not end with either an EXIT or QUIT.

So, just include either one if you do not want to see the warning.

Thanks,
Shiyamala