mload step
- .LOGTABLE truser2.logtable;
- .LOGON 127.0.0.1/truser2,trpass2;
- .begin import mload tables coldata_test WORKTABLES wt_test1 ERRORTABLES wt_test1 uv_test1 ERRLIMIT 1000 CHECKPOINT 100000 AMPCHECK NONE;
- .layout test_layout; .field col01 * varchar(255); .field col02 * varchar(255); .field col03 * varchar(255);
- .DML LABEL test_insert
- IGNORE MISSING UPDATE ROWS
- DO INSERT FOR MISSING UPDATE ROWS;
UPDATE coldata_test SET col02 =:col02 ,col03 = :col03 where col01 = :col01;
insert into coldata_test values( :col01, :col02, :col03);
.IMPORT INFILE /home/tdatuser/bin/data2.dat LAYOUT test_layout FORMAT VARTEXT ',' APPLY test_insert;
- .END MLOAD;
- .LOGOFF;
data2.dat : abdfe,aasf,xxcvf
result : This MultiLoad import task cannot proceed: an unexpected MultiLoad phase, data acquisition, was reported by the RDBMS.
what is problem??