Error while running BTEQ

Tools
Enthusiast

Error while running BTEQ

Hello,

While running following bteq script

BTEQ
.LOGON tddev/aedwenr1,enrich1
.EXPORT FILE=out_betq.txt
SHOW TABLE db_wrk.test_exec_pmr;
.EXPORT RESET
.LOGOFF
.EXIT

I get the error you musy logon before sending DBC/SQL statements.

What am I missing?

I use the the syntax to run:
bteq log.txt

Thanks In advance,
2 REPLIES
Enthusiast

Re: Error while running BTEQ

The first line ie BTEQ is not needed.The below code alone would work

.LOGON tddev/aedwenr1,enrich1
.EXPORT FILE=out_betq.txt
SHOW TABLE db_wrk.test_exec_pmr;
.EXPORT RESET
.LOGOFF
.EXIT

Let me know if it dosent help.

Thanks,
Shiyamala
Enthusiast

Re: Error while running BTEQ

Thanks