How to catch EXECUTE command errors/messages.

[gines_rueda]

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 · Accepted solution]

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]

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