I am relatively new to Teradata and am having issues w/ creating a BTEQ script which will logon and export data. The issue is w/ the logon command, I cannot get it to recorgnize my password. I have no problem w/ executing an import script w/ FastLoad that has the credentials embedded, but BTEQ won't recognize from script or interactive mode. We are using teradata version: 14.00.07.12 .
My script looks like:
Hi.
In bteq "interactive mode" you cannot .LOGON with the password appended to the username with a comma. It only works this way in "batch mode".
You must provide the DBCop/Username only and then answer when interactively prompted for the password.
HTH.
Cheers.
Carlos.
Thanks for the tip. I did try passing the password in batch mode using various combinations of quotes/no quotes on both the password and userid. It turns out that I loacked the account during these tries but didn't know that because I still received the same invalid user/account message.
check if your login mechanism is LDAP n include it
.LOGMECH LDAP;