All Forums Tools
Buddy 1 post Joined 01/06
15 Mar 2006
BTEQ logon problem

Hi,I am using the following syntax to logon to Teradata Demo thru BTEQ/BTEQWin:.logon demotdat/dbc,dbc;and having the following error:*** Error: Invalid logon!*** Total elapsed time was 1 second.Teradata BTEQ 08.02.00.00 for WIN32. Enter your logon or BTEQ command:The hosts file shows the following:127.0.0.1 localhost DemoTDAT DemoTDATcop1Hovewer when I use .logon demotdat/dbcwithout specifying its password, it prompts for a password... when I type in its password, I am able to logon.Could someone shed a light why I cannot use the Batch Mode?

Fred 1096 posts Joined 08/04
17 Mar 2006

BTEQ only accepts the "batch mode" form of .LOGON while it is reading commands from a file, e.g. when input is redirected on the command line that invokes BTEQ.You can use the .RUN FILE= command to temporarily redirect input, even during an (otherwise) interactive session.

MATIZ 1 post Joined 02/06
21 Mar 2006

YOU CAN NOT USE .LOGON TDPID/USERNAME,PASSWORDIN INTERACTIVE MODETHIS WAY USE IN BATCH MODEIN INTERACTIVE MODE use this.LOGON TDPID/USERNAME 'PRESS ENTER'.LOGON TDPID/USERNAME PASSWORD: 'ENTER HERE YOUR PASSWORD'AND THAT IS IT

Dany3R9 18 posts Joined 03/14
18 Feb 2015

using BTEQ:
.logon <DB>(name or IP)/<user> [press enter]
Password: <your password>  [press enter]
Bye

You must sign in to leave a comment.