Common SQL Return Codes for DB2

No row meets the search conditions specified in a DELETE, UPDATE, or FETCH operation; or table is empty.

Successful execution.

SQL syntax error. Run trace to determine nature of translation error.

The table specified by TABLENAME in the FOCUS Access File does not exist.

The SQL column name, defined by the ALIAS parameter in either the FOCUS Master or Access File, does not exist within the target TABLENAME.

The USAGE type or length defined for a field in the FOCUS Master does not conform to the corresponding column definition in the SQL table.

There is a null value within a predicate (-309) or within an update statement (-407) where nulls are not allowed.

You tried to perform an action within SQL for which you are not authorized.

You tried to create a table, index, or view using a name that already exists.

You tried to create a table that contains duplicate SQL column names. Check each Master File segment for unique ALIAS values.

You tried to include or update a value within a column for which a UNIQUE INDEX exists, and that value is already present.

A resource is unavailable. Refer to the DB2 messages and codes manual in order to evaluate the situation.

A resource limit based on the DB2 RLST Governor has been exceeded. There are rows in the SYSIBM.DSNRLST00 table that pertain to this resource and the limits placed on it. Consult your DB2 DBA to find out what action is necessary.

The application was the victim in a deadlock or experienced a timeout.