I am new to Teradata and was trying to setup something similar to sql loader to load delimited files into tables.
Below is the script i ran from my unix prompt.
tdload -c ASCII -j tdloadjobvars.txt
Below are the contents of my "tdloadjobvars.txt" file.
TargetWorkingDatabase = 'xxxx',
SourceFileName = 'tdload.csv',
TargetTable = 'tdload_1',
SourceTextDelimiter = ',',
TargetMaxSessions = 5
I am getting the following error message.
Teradata Load Utility Version 13.00.00.12
Got RDBMS Error 8017: The UserId, Password or Account is invalid.
I can logon using BTEQ and FASTLOAD utility.
Can anyone help?
The same as you. I need help too.
Seems like "tdload" does not support any kind of target "LogonMech" other than the default td2. Hence your ldap database access can't be used.
IE Only a full tpt script will allow ldap authentication.