|
|
|
Forum Newbie
Group: Forum Members
Last Login: 9/14/2006 2:08:00 PM
Posts: 1,
Visits: 1
|
|
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?
Santiago Luz
|
|
|
|
|
Supreme Being
Group: PAC and SFT Members
Last Login: Today @ 12:57:26 PM
Posts: 328,
Visits: 506
|
|
|
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".
|
|
|
|
|
Forum Newbie
Group: Forum Members
Last Login: 11/11/2008 5:21:25 PM
Posts: 2,
Visits: 12
|
|
|
can any one help me to know how we can avoid this message
|
|
|
|
|
Supreme Being
Group: Forum Members
Last Login: 11/12/2008 9:19:53 PM
Posts: 469,
Visits: 463
|
|
if you are so particular about it, then this is the way ...
(
cat loginFile
cat MySQLsFile
echo ".QUIT;"
) | bteq
|
|
|
|
|
Junior Member
Group: Forum Members
Last Login: 11/12/2008 12:15:47 PM
Posts: 13,
Visits: 29
|
|
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
|
|
|
|