Error mode in script

ajsjoshua — Sat, 16 Nov 2024 04:57:48 GMT

Dear all,

I have used error mode to bypass an error in script but unfortunately its not working.Actually the table is saved into qvd for plant '1007', '1002', '1005', '1003', '1001', '1144' but for the plant '1006' the table is not saved into qvd.I want to skip the this script even if the table is not available for the plant '1006'.pls suggest me some ideas.

set ErrorMode=0;
for each Plant in '1007', '1002', '1005', '1003', '1001', '1144', '1006'
[ZQM_SP_FM_Z321STAT]:
LOAD *;
SQL {
"function":
[ "" ]
}
]
}
]
};

store [ZQM_SP_FM_Z321STAT] into E:\DATA\ZSTATUS_$(Plant)_$(vFileName).qvd(qvd);
drop table [ZQM_SP_FM_Z321STAT];
next

if ErrorMode= 0 then

end if

My log file says

Error: Connector reply error:
2018-12-11 05:14:37 LOCATION CPIC (TCP/IP) on local host with Unicode
2018-12-11 05:14:37 ERROR no conversation found with id 07999734

topic Error mode in script in QlikView

Error mode in script