Logon through BTEQ

[Liam1]

Hello,

I have been using the script
.logon NameInHostFile/UserName,PWord

as in DOT Logon connection name in host file FORWARD SLASH username COMMA password

This seems to have stopped working over night.
"Error Invalid Logon!!" is generated.

I cannot put my password within the same connection string.
I have to wait for it to prompt me.

Is this a switch that might have been turned off?

Am I doing something wrong?

Thanks in advance

Liam1

 

[dnoeth]

The password may be included if you run a script,
e.g. &quot;.run file = mylogon;&quot; or &quot;bteq < myscript&quot; on command line.
If you run it in interactive mode or cut/paste the logon string, the password is not allowed.

Dieter

 

[Liam1]

Dieter,

I am using the &quot;bteq < Myscript&quot; method described above.
I am running this through an Access created interface that used to work.
I have created a batch file that that uses an input file and creates an output file to view the errors. If i enter the password within the script that is executed by the btach file, it crashes, if i leave the password out, it wil run, but prompts me for a password.

Am I doing something wrong?

.logon GDWProd/PLLXD,********

Thanks,

Liam

 

[dnoeth]

Looks ok to me, did you try to run the batch in command line?
If it runs it's an Access problem and i can't help you with that....

Dieter

 

[Liam1]

Dieter,

Everything is now fine! )
It might be usefull for you to know that the file names you use can only be a finite length.
I was using a path to the files that was quite long (over 80 chars?) and this seemed to make Teradata ignore the logon part, Was it wrapping the text around the line feed?
I have put the files into a much smaller directory path string (about 20 chars) and it works.
Thanks,
Liam.