Hi all,
I am running the below script
Sales:
LOAD business_date,
bc_id,
business_unit,
rvc_num,
rvc_name,
chk_num,
chk_seq,
r_type,
mi_obj_num,
mi_name,
majgrp_name,
famgrp_name,
migrp_name,
record_name,
record_type,
ord_type,
chk_open_date,
chk_open_time,
chk_close_date,
chk_close_time,
chk_open_hour,
chk_close_hour,
waiter_name,
table_no,
cust_cnt,
quantity,
d_chk_ttl,
sub_ttl,
tax_ttl,
pymnt_ttl,
tips_ttl,
cost,
chk,
H_Flag
FROM $(vSalesQvdName) (qvd)
where business_date < $(v45days);
concatenate(Sales)
Load business_date,
bc_id,
business_unit,
rvc_num,
rvc_name,
chk_num,
chk_seq,
r_type,
mi_obj_num,
mi_name,
majgrp_name,
famgrp_name,
migrp_name,
record_name,
record_type,
ord_type,
chk_open_date,
chk_open_time,
chk_close_date,
chk_close_time,
chk_open_hour,
chk_close_hour,
waiter_name,
table_no,
cust_cnt,
quantity,
d_chk_ttl,
sub_ttl,
tax_ttl,
pymnt_ttl,
tips_ttl,
cost,
chk,
H_Flag;
SQL
set transaction isolation level read uncommitted
select * from Fandb.[dbo].[BI_MicrosSalesData] where [business_date] >= '$(v45dayDate)';
After running the above script , sometimes we are getting OLE DB connection failure. In this case i need to make a rollback or if possible retry to reconnect.
if the connection error persist, i need to get the qvd as it is.
Please advise what function should i use to catch the connection error.
Thanks.
