positive errors means +100 it will work but it gives some warnings ..etc
+100 means no more data after fetching the last one in a resultant table(cursor).
-818 time stamp token mismatch between Application plan and loadmodule this is severe error that is negative...
but both the cases u have to handle the situation with Handle condition are else best method is SQLCODE..OR SQLSTATE....DEPends on ur application design.
all d best