Is EIM Set Based or Record Based
Hi,
Good day.
I have one query. When we run siebel EIM , does the inserts/updates run record by record from eim table or does it run batch by batch (all records in the batch run at same time ) , which is like set based mode.
so in turn,
does eim form the query as
1. Insert into s_asset (<>,<>,<>) select <>,<>,<> from eim_asset;
or
2. cursor c1 is select <> , <> , <> from asset;
for c1 in rec
insert into s_asset (<>,<>,<>) values <>,<>,<> ;
regards,
Jasjit
Good day.
I have one query. When we run siebel EIM , does the inserts/updates run record by record from eim table or does it run batch by batch (all records in the batch run at same time ) , which is like set based mode.
so in turn,
does eim form the query as
1. Insert into s_asset (<>,<>,<>) select <>,<>,<> from eim_asset;
or
2. cursor c1 is select <> , <> , <> from asset;
for c1 in rec
insert into s_asset (<>,<>,<>) values <>,<>,<> ;
regards,
Jasjit
0