+100

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

0

Successful execution.

-104

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

-204

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

-205

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

-301
-302

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.

-309
-407

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

-551 
-552

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

-601

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

-612

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

-803

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

-904

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

-905

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.

-911
-913

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

-923

DB2 is not operational.