Multiload Unformat Command

Tools

Multiload Unformat Command

I need help on the Unformat command.

I wrote a mload script and it ran fine but did not read any records from the file.

I used the Format Unformat command in the Import.
2 REPLIES
Enthusiast

Re: Multiload Unformat Command

Hi,
Could you pls post the extract of the script you used?

Re: Multiload Unformat Command

Below is the script I used for loading. It ran fine but did not read a single record from the file.

.LOGTABLE emp_log;

.logon ishu/ishu,ishu;

.BEGIN IMPORT MLOAD
TABLES emp
WORKTABLES emp_wk
ERRORTABLES emp_uv
emp_et

ERRLIMIT 100
CHECKPOINT 5

TENACITY 1
AMPCHECK NONE
SESSIONS 1
;

.LAYOUT Emp_Table;
.TABLE emp;

.DML LABEL Insert_Add;
INSERT INTO emp
(
Emp_no = :Emp_no
,emp_name = :emp_name
,emp_salary = :emp_salary
,Join_date = :Join_date

);

.IMPORT INFILE C:\test.TXT LAYOUT Emp_Table FORMAT UNFORMAT APPLY Insert_Add
;

.END MLOAD;

.LOGOFF;