Error while running BTEQ

Visit Teradata.com

Home

Guidelines

Member List

Welcome Guest ( Login | Register )

This online forum is for user-to-user discussions of Teradata products, and is not an official customer support channel for Teradata. If you require direct assistance, please contact Teradata support.

Error while running BTEQ

Rate Topic

Display Mode

Topic Options

Author

Message

newbie_123

Posted 9/5/2008 10:27:28 AM

Forum Newbie

Group: Forum Members
Last Login: 9/5/2008 3:44:38 PM
Posts: 9, Visits: 32

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,

Post #12829

shiyamala

Posted 9/5/2008 3:19:02 PM

Junior Member

Group: Forum Members
Last Login: 11/12/2008 12:15:47 PM
Posts: 13, Visits: 29

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

Post #12832

newbie_123

Posted 9/5/2008 3:45:23 PM

Forum Newbie

Group: Forum Members
Last Login: 9/5/2008 3:44:38 PM
Posts: 9, Visits: 32

Thanks

Post #12833

« Prev Topic | Next Topic »

Reading This Topic

Active Users: 0 ( 0 guests, 0 members, 0 anonymous members )

No members currently viewing this topic.

All times are GMT -5:00, Time now is 11:18pm