Testing the value of SQLCODE is the most common way of determining the success or failure of an embedded SQL statement.
For details of SQLCODE values, see the topic SQLCODE Values.