Unlock a world of possibilities!
now and discover the exclusive benefits awaiting you.
Thanks in advance.
I have three QVD of three tables i.e.orders, payment and refunds.
And in my main Transformation qvd i am doing full outer join of this three table.
suppose if payment qvd vice versa is not presnt then script get failed , my requirement is if payment qvd is not presnt then also script should run with
easiest metod is to use errormode switch
set errormode = 0;
set errormode = 1;
Another common solution would be to check for the QVD timestamp
How can I check if a file exists ?
Same is discussed here Command to check if a QVD file exists How can I check if a file exists ?
It may help you.