Error handling after a SQL statement – PB Docs 125

When to check for errors

You should always test the success or failure code (the SQLCode property of the Transaction
object) after issuing one of the following statements in a script:

• Transaction management statement (such as CONNECT, COMMIT,
  and DISCONNECT)

• Embedded or dynamic SQL

Not in DataWindows

Do not do this type of error checking
following a retrieval or update made in a DataWindow.

For information about handling errors in DataWindows,
see the DataWindow Programmers Guide.

SQLCode return values

Table 12-4 shows
the SQLCode return values.

Using SQLErrText and SQLDBCode

The string SQLErrText in
the Transaction object contains the database vendor–supplied
error message. The long named SQLDBCode in
the Transaction object contains the database vendor-supplied status
code. You can reference these variables in your script.