UTY2403 An invalid statement was found before the .LOGON statement

Tools & Utilities
N/A

UTY2403 An invalid statement was found before the .LOGON statement

I am getting this error while running the mload:
02:42:25 UTY2403 An invalid statement was found before the .LOGON statement.
02:42:25 UTY2410 Total processor time used = '0 Seconds'

Please help me!!!!
3 REPLIES
Enthusiast

Re: UTY2403 An invalid statement was found before the .LOGON statement

There is often a clue in the script you submitted!
Check your script had a .Logon, not Logon.
Failing this, post your script.
Teradata Employee

Re: UTY2403 An invalid statement was found before the .LOGON statement

.Logtable students.log9202; .LOGON 192.168.219.128/students,learning13; .BEGIN IMPORT MLOAD TABLES STUDENTS.MLOAD_EMP; .LAYOUT UPD_PHONE; .FIELD EMPID 1 Integer; .FIELD PHONENO * Integer; .DML LABEL DML_LBL DO INSERT FOR MISSING UPDATE ROWS; UPDATE STUDENTS.MLOAD_EMP SET phone_number=:PHONENO WHERE EMPID=:EMPID; INSERT INTO STUDENTS.MLOAD_EMP(:EMPID,:PHONENO); .IMPORT INFILE C:\Users\AA255056\Desktop\Multiload\Files\emp_phone.txt LAYOUT UPD_PHONE FORMAT VARTEXT ',' APPLY DML_LBL; .END MLOAD; .LOGOFF;

 

Getting the same error. Can you please help ? Script looks good.

Tags (1)
Teradata Employee

Re: UTY2403 An invalid statement was found before the .LOGON statement

I took your script and ran it and did not have a problem at all.

Of course, the script you posted seems to all be one long line.

I added newlines after each command and the script worked just fine.

 

-- SteveF