Skip to main content
Announcements
Marching toward a simplified navigation! READ ON
cancel
Showing results for 
Search instead for 
Did you mean: 
sunil1989
Contributor
Contributor

Avoid Qvd if not present in script??

Hi ,

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.

orders

join

payment

join

Refund

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

orders

join

Payment.

Thanks,

Sunilkumar

3 Replies
tunoi
Creator
Creator

easiest metod is to use errormode switch

set errormode = 0;

orders

join

payment

join

Refund

set errormode = 1;

quwok
Creator III
Creator III

Another common solution would be to check for the QVD timestamp

How can I check if a file exists ?

Siva_Sankar
Master II
Master II

Hi Sunil,

Same is discussed here Command to check if a QVD file exists How can I check if a file exists ?

It may help you.

Siva