Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello All,
I am trying to perform incremental load (Insert only) on large volume of data, some times due to OLEDB errors only partial data loaded and missing some of the data. So i tried that if any errors occurs in script we have to exit the entire script without storing the data into Qvd.
My Logic was not working. Am sharing the script what we used Please suggest me Regarding this issue.
Script:
Payments:
LOAD locid,
locstatementdetailid,
ltapportioncodeid,
keydate
FROM
$(vQvdPath)Payments.Qvd (qvd);
Temp:
LOAD keydate Resident Payments order by keydate;
let vMaxKeyDate = Peek('keydate',-1,'Temp');
drop Tables Payments,Temp;
NoConcatenate
Payments:
LOAD locid,
locstatementdetailid,
ltapportioncodeid,
keydate;
SQL
SELECT * FROM $(vSourcePath)Payments Where keydate > '$(vMaxKeyDate)';
Concatenate(Payments)
LOAD locid,
locstatementdetailid,
ltapportioncodeid,
keydate
FROM
$(vQvdPath)Payments.Qvd (qvd);
If ScriptError >= 1 then
Exit script;
End if
STORE Payments into $(vQvdPath)Payments.Qvd(qvd);
drop table Payments;
Payments:
LOAD locid,
locstatementdetailid,
ltapportioncodeid,
keydate
FROM
$(vQvdPath)Payments.Qvd (qvd);
Try to chnage your script error variable
SET ErrorMode=0;
Payments:
LOAD locid,
locstatementdetailid,
ltapportioncodeid,
keydate
FROM
$(vQvdPath)Payments.Qvd (qvd);
Temp:
LOAD keydate Resident Payments order by keydate;
let vMaxKeyDate = Peek('keydate',-1,'Temp');
drop Tables Payments,Temp;
NoConcatenate
Payments:
LOAD locid,
locstatementdetailid,
ltapportioncodeid,
keydate;
SQL
SELECT * FROM $(vSourcePath)Payments Where keydate > '$(vMaxKeyDate)';
Concatenate(Payments)
LOAD locid,
locstatementdetailid,
ltapportioncodeid,
keydate
FROM
$(vQvdPath)Payments.Qvd (qvd);
If ScriptErrorCount > 0 then
Exit script;
End if
STORE Payments into $(vQvdPath)Payments.Qvd(qvd);
drop table Payments;
Payments:
LOAD locid,
locstatementdetailid,
ltapportioncodeid,
keydate
FROM
$(vQvdPath)Payments.Qvd (qvd);
Have you set the error mode to 0?
SET ErrorMode = 0;
Try to chnage your script error variable
SET ErrorMode=0;
Payments:
LOAD locid,
locstatementdetailid,
ltapportioncodeid,
keydate
FROM
$(vQvdPath)Payments.Qvd (qvd);
Temp:
LOAD keydate Resident Payments order by keydate;
let vMaxKeyDate = Peek('keydate',-1,'Temp');
drop Tables Payments,Temp;
NoConcatenate
Payments:
LOAD locid,
locstatementdetailid,
ltapportioncodeid,
keydate;
SQL
SELECT * FROM $(vSourcePath)Payments Where keydate > '$(vMaxKeyDate)';
Concatenate(Payments)
LOAD locid,
locstatementdetailid,
ltapportioncodeid,
keydate
FROM
$(vQvdPath)Payments.Qvd (qvd);
If ScriptErrorCount > 0 then
Exit script;
End if
STORE Payments into $(vQvdPath)Payments.Qvd(qvd);
drop table Payments;
Payments:
LOAD locid,
locstatementdetailid,
ltapportioncodeid,
keydate
FROM
$(vQvdPath)Payments.Qvd (qvd);