I am using the MLOAD script in UNIX:
.RUN FILE /work/user/user1;
DROP TABLE wrktab;
DROP TABLE ettab;
DROP TABLE uvtab;
.FIELD IN_STRTGY_SRC_CD 1 CHAR(2) NULLIF IN_STRTGY_SRC_CD=' ';
.FIELD IN_TACTIC_ID 3 CHAR(50) NULLIF IN_TACTIC_ID=' ';
.FIELD IN_TRGT_TYP_CD 53 CHAR(3) NULLIF IN_TRGT_TYP_CD=' ';
.FIELD IN_EVNT_ACTVY_TYP_CD 56 CHAR(2) NULLIF IN_EVNT_ACTVY_TYP_CD=' ';
.FIELD IN_EVNT_ACTVY_TYP_CD_VRSN 58 CHAR(2) NULLIF IN_EVNT_ACTVY_TYP_CD_VRSN=' ';
.FIELD IN_ENCODING_IND 60 CHAR(1) NULLIF IN_ENCODING_IND=' ';
.FIELD IN_FIELD_DESC 61 CHAR(17) NULLIF IN_FIELD_DESC=' ';
.FIELD IN_FILENAME 78 CHAR(50) NULLIF IN_FILENAME=' ';
.FIELD IN_FILENAME_SUFFIX 128 CHAR(8) NULLIF IN_FILENAME_SUFFIX=' ';
.FIELD IN_VNDR_TRANSMISSION_CD 136 CHAR(2) NULLIF IN_VNDR_TRANSMISSION_CD=' ';
.FIELD IN_EMAIL_NOTIF_ADDR 138 CHAR(30) NULLIF IN_EMAIL_NOTIF_ADDR=' ';
.FIELD IN_PROCESS_TYP 168 CHAR(1) NULLIF IN_PROCESS_TYP=' ';
.FIELD IN_USRID 169 CHAR(8) NULLIF IN_USRID=' ';
.FIELD IN_FILLER 177 CHAR(4) NULLIF IN_FILLER=' ';
.FIELD IN_TIMESTAMP 181 CHAR(26) NULLIF IN_FILLER=' ';
.DML LABEL INSERT_FINEREC;
INSERT INTO tbl1
.IMPORT INFILE /work/scripts/cmpbypass/temp/finerec.txt
and getting the error:This MultiLoad import task cannot proceed: an unexpected MultiLoad phase, data acquisition, was reported by the RDBMS.
It would be helpful to see the entire MultiLoad output, but without that I can answer that the issue has to do with a synchronization problem between MultiLoad and the database.
They both have to be in sync with each other on a restart.
In other words, MultiLoad cannot think that the restart should resume in the DML Phase while the database thinks the job needs to resume in the Acquisition Phase.
If this was an initial job, then it could signal that the restart logtable exists from a previous job.
So, in order to assist more, I would need to know more speficia about the job.
thanks for the reply. The issue was , i was using different temp and error table names. It is working now. thanks agian.