differnces sources of data that we load into mload

General

differnces sources of data that we load into mload

hi,

Any body please help that actually wt type of data can be load ,and how can we load i.e I need sources data with eaxmples (format,vartext) and i am giving the example wt type of data we laod for this one
.logtable empdept_log;
.logon 127.0.0.1/sql01,sql01;
begin import tables emp12,dept12
worktables emp21_wt,dept21_wt;
errortables emp21_et emp21_uv,
dept21_et dept21_uv;
.layout filein
.filler trans * char(1);
.field emp_no * integer;
.field dept_num * integer;
.field lname * char(20);
.field fname * varchar(20);
.field sal * decimal(10,2);
.field deptno 2 integer;
.field deptname * char(20);
.dml label empin
ignore duplicate insert rows;
insert into emp21 values(:empno,:fname,lname,:sal,:dept_sum);
.dml label deptin ;
update department_table set dept_name =:deptname
where dept_no = : deptno;
.import infile lld.txt
layout filein
apply empin where trans='E'
apply deptin where trans='D'
.end mload;
.logoff;

for this how the source data,

advance thanks to all
1 REPLY

Re: differnces sources of data that we load into mload

mlaod