I'm new to Teradata and am running into an error trying to execute an MLOAD process. I keep getting the error "An invalid statement was found before the .LOGON statement" and no matter what I've tried I can't seem to get past this. Even the people in my department who are familiar with teradata seem stumped.
My script looks like this...
Are you sure you do not have any hidden characters in the file prior to the .logtable command or in between the .logtable and the .logon command?
I am also facing a similar problem and getting the same error for my fast export script. I have used the same format for another script and that is working fine. I checked this script throughly and am still not able to get where I did the mistake. Can some one please help me out here. here are the first 4 lines of the script
.RUN FILE LOGON_FILE;
.SET MAXERROR 1;
ABC.WORK_TBL - work table
LOGON_FILE - .logon file containing .logon tdpid/Loginid,pwd;
Well, we have tried this inhouse and do not have any problems with:
.logtable . . . . ;
.run file . . . . ;
.set maxerror . . . ;
database . . . ;
and we do not get any type of errors (assuming the file for the RUN FILE command has the .logon statement).
Please post the entire output from the job.
And the job script as well.
Please update yor TTU to newer version, that will fix the problem , TTU 7 and older versions are may not compatable with your code.