BTEQ throws error when session parameter maxerror is set to 1 and SQL script is executed with .run file,
it doesn't throw error when SQL script is executed with .compile file
Is there any hack for that?
Thanks in advance :-)
.compile file option doesn't even raise errorlevel, even if there are errors in procedure definition,
I can't find any way to catch it's errors
.if errorlevel > 0 doesn't work either
Sooooo, there is solution, but a "bit" desperate.
We can save BTEQ output to file and search it for SPL errors right after running BTEQ with .compile file option.
We must deal with syncing saving of log file and searching for errors.