Teradata Express bteq logon issue

UDA

Teradata Express bteq logon issue

I am playing with Teradata Express for VMware Player and unable to connect to db using bteq

>bteq

  1. logon dbc/dbc
  2. dbc

****warning: you must logon before sending dbc/sql requres.

Thanks for your hlep.

 

Tags (1)
3 REPLIES
N/A

Re: Teradata Express bteq logon issue

Hi,

i have created a very simple BTEQ script Which looks like :

.logon tdpid/username,password; 

sel * from <tablename>

.quit

.logoff

script was succesfully executed but,

i am getting return code=2

warning: you must logon before sending dbc/sql requests.

how to resolve this?

N/A

Re: Teradata Express bteq logon issue

can anyone help me please...

Re: Teradata Express bteq logon issue

Rathod,

Error code 2 occurs only if

1.we are not included the login statement in the script

2.submitting a request after logoff statement

it seems second criteria applicable to you. i commentted the logon statement hence BTEQ exited with return code 2

BTEQ 14.10.00.10 Wed Apr 15 01:34:09 2015 PID: 27807

+---------+---------+---------+---------+---------+---------+---------+----

--.logon tdpid/username,password;

sel * from t1_anil;

+---------+---------+---------+---------+---------+---------+---------+----

.quit

 *** Exiting BTEQ...

 *** RC (return code) = 2