Conditional DML With Example Explanation

Posted by Ab Initio Coach at 5:47:00 AM

Conditional DML is known as DML that is used as condition.

we can write the conditional dml where header and trailer data accoured,
data format is like this

"""
H,12/10/16,a.dat,
D,121,damu,1000,
D,131,raju,2000,
D,141,reddy,3000,
T,3,

"""

conditional dml record format is like this below i explained with example

""""

record
string(",")id;
if(id=="H")
begin
date(",") date1;
string(",") file_name,
end
else if(id=="D")
begin
decimal(",")emp_id;
string(",")emp_name;
string(",")salary;
end
else if(id==T)
begin
decimal(",")count;
end
end;


"""""

Like this conditional dml record format we can write in abinitio mostly accrued in bank projects,health care,trading projects