Archives of the TeradataForum

Message Posted: Thu, 19 Sep 2002 @ 18:36:37 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

For BTEQ, BtewWin, DMTEQ, interactive mode and reading a file or script DO NOT WORK THE SAME for the .LOGON command. I'm not sure about why you cannot specify a fully qualified host name.

I'm not sure why clispb.dat is being ignored. try putting clispb.dat in the same directory as bteq/bteqwin/dmteq.

As follows:
------------------------------------
 Teradata DMTEQ 06.01.00.00 for WIN32. Enter your logon or BTEQ command:
/*
   You can't specify in interactive mode your password
   on the same line as your host name and userid
   (probably because it would be echoed and not hidden).
*/
.logon slgo1093.up.com/cttd051,mypassword
.logon slgo1093.up.com/cttd051,mypassword

 *** Error:  Invalid logon!

 *** Total elapsed time was 1 second.

 DMTEQ -- Enter your DBC/SQL request or BTEQ command:
/* You can specify the password on the same line if the logon is run from a file.
   My file/script C:\Program Files\NCR\Teradata Manager
5.0.1\bin\mylogon.sql
   looks like this one line
   .logon slgo1093.up.com/cttd051,mypassword
*/
.run file = mylogon.sql
.run file = mylogon.sql
 DMTEQ -- Enter your DBC/SQL request or BTEQ command:
.logon slgo1093.up.com/cttd051,

 *** Logon successfully completed.
 *** Transaction Semantics are BTET.
 *** Character Set Name is 'ASCII'.

 *** Total elapsed time was 1 second.

 DMTEQ -- Enter your DBC/SQL request or BTEQ command:
 *** Warning: EOF on INPUT stream.
 *** Warning: EOF on INPUT stream.
 DMTEQ -- Enter your DBC/SQL request or BTEQ command:
-----------------------------------
I'm guessing from your reply (below) that you tried these interactively?
-----------------------------------
This logon statement works:
.logon myuser (enter)
Mypass

These don't:
.logon myuser, mypass
.logon hostname.fully.qualified/myuser, mypass
.logon hostname/myuser, mypass
.logon dbc/myuser, mypass
.logon hostname.fully.qualified/myuser (enter)
Mypass
.logon hostname/myuser (enter)
Mypass
.logon dbc/myuser (enter)
Mypass

Teraminer generates this logon command:

.logon hostname.fully.qualified/myuser, mypass

Which doesn't work. I don't think I'm going to be able to change the way that teraminer outputs the .logon command, so I need to get this form of the logon command to work.

I also tried editing the clispb.dat file as suggested in another reply. With or without the change (i_dbcpath=dbc to i_dbcpath = hostname.fully.qualified) I still have the same problem.

	<Prev	Next>		<<First	<Prev	Next>	Last>>