.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.
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.