Avoid Qvd if not present in script??

[sunil1989]

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

[tunoi]

easiest metod is to use errormode switch

set errormode = 0;

orders

join

payment

join

Refund

set errormode = 1;

[quwok]

Another common solution would be to check for the QVD timestamp

How can I check if a file exists ?

[Siva_Sankar]

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