In PowerBuilder, you can check whether a SQL statement is failed or not using SQLCode and SQLDBCode variables.

SQLCode contains one of the following return code after SQL statement execution:

• 0 - Successful execution
• -1 - The statement failed. Use SQLDBCode to obtain the details (see below)
• 100 - No rows found

SQLDBCode contains the database vendor-supplied status code.

For example, for Informix database, SQLDBCode contains the value -239 if a row cannot be inserted due to duplicate value in unique index.