Problem with bteq

Tools
Enthusiast

Problem with bteq

I was running an update bteq script and i got the following error:

UPDATE SCRIPT HERE

*** Total elapsed time was 18 minutes and 43 seconds.

*** Update completed. 196376 rows changed.
*** Total elapsed time was one hour, 12 minutes and 40 seconds.

+---------+---------+---------+---------+---------+---------+---------+----

.IF ERRORLEVEL <> 0 THEN .GOTO JobAbend
.GOTO JobAbend

even though update was done ... the job got terminated ..
Please help me out
2 REPLIES
Enthusiast

Re: Problem with bteq

My guess would be that the .GOTO JobAbend in the line after the .IF statement would be causing the trouble for you ?
Enthusiast

Re: Problem with bteq

i think the error was because of the data ... the table that i was updating was a 'set table' that might be the reason i guess ...

I had pasted the o/p of the log file above .. hence there is a .GOTO JobAbend in the line after the .IF statement .. as it found the error