In all previous version, sql return code in stored procedure for successfull is 0.( Row found). But in TD14 it is 3705. Is any body notice is this ? why there is different sql return code for row found ? any thoughts.
I will check this on TD 14 environment but in Teradata, return code ZERO means the execution was successful without any warnings or errros. I don't think this has changed in TD 14.
BTW return code 3705 means that the request executed in interpretive EVL mode. (You can check the descriptions of the error codes from dbc table DBC.ERRORMSGS).
An older post from the archieve but an interesting one to understand the interpretive and executable EVL...
I was taking about sql return code in stored procedure, before TD14, it was 0. Now it is 3705. We have n't changed any thing in stored procedure, it was executing thru sq assistant.
We had stored procedure works correctly in TD13, when we moved to TD14 , it was not working, the return code has changed from 0 to 3705.
not sure why it is ?
The first thing is that the return codes and error codes are ususlly univeral and not changed often with version change.
What I have found about the error code 3705, It is just a warning. not an error. You can read the more details about it from the below link:
The dbscontrol settings might be different or the optimizer is doing some enhanced optimizations which don't fit in the segment anymore.
Nevertheless the code run successfull, you might simply add a CONTINUE HANDLER for this warning.