Re: Return code in SPL

Adam I use the following statements if (sqlca.sqlcode < 0) then display "error ", sqlca.sqlcode rollback work else commit work end if within my stored procs. Are you running this code in ISQL or are you executing the stored procedure from ISQL? Adam Pribek wrote: } Hi All, } } can somebody tell me how can I check the sqlcode in SPL? } I think it should be something like this: } if sqlca.sqlcode < 0 then ... } endif, } but when I tried this, the SQL Editor (OnLine Workgroup Server 7.2) } said } it had syntax error. } } Suggestions? } } Thanks } Adam