sqlca.sqlcode

returns the SQL code of the  last SQL command

 

0 = ok

100 = entry not found

<0 = error

 

see sql error handling