topic How to catch EXECUTE command errors/messages. in QlikView

How to catch EXECUTE command errors/messages.

gines_rueda — Wed, 09 Sep 2015 11:30:03 GMT

Hello,

Is there a way to retrieve the error message that cmd.exe gives when I run this sentence in my QV script?

EXECUTE cmd.exe /C del "H:\file.csv" /q;

My point is that the file could be opened by a third party then the file would not be deleted, and no error or message will be return.

Thanks.

Ginés.

maxgro — Wed, 09 Sep 2015 11:35:10 GMT

try with

EXECUTE cmd.exe /C del "yourfile" /q 2> delete.err;

the error should be written in the file delete.err

and then you can read (if exists) the file with Qlik

gines_rueda — Fri, 11 Sep 2015 13:54:40 GMT

It would be nicer if this is captured by qlikview, but thanks, it worked.