# Db2 SQLCODEs Source: https://wndsoftware.com/mainframe-errors/db2-sqlcodes ### Db2 SQLCODEs Look up Db2 SQLCODEs, their diagnostic details and possible fixes. Search a code or message ### All 104 codes - [`SQLCODE -010`String constant not terminated](https://wndsoftware.com/mainframe-errors/sqlcode-10) - [`SQLCODE +100`Row not found](https://wndsoftware.com/mainframe-errors/sqlcode-100) - [`SQLCODE -101`Statement too long or too complex](https://wndsoftware.com/mainframe-errors/sqlcode-101) - [`SQLCODE -104`Illegal symbol in the statement](https://wndsoftware.com/mainframe-errors/sqlcode-104) - [`SQLCODE -117`Number of values doesn't match columns](https://wndsoftware.com/mainframe-errors/sqlcode-117) - [`SQLCODE -119`Column or expression in HAVING not valid](https://wndsoftware.com/mainframe-errors/sqlcode-119) - [`SQLCODE -120`Aggregate function not valid in context](https://wndsoftware.com/mainframe-errors/sqlcode-120) - [`SQLCODE -122`Column or expression in SELECT list not valid](https://wndsoftware.com/mainframe-errors/sqlcode-122) - [`SQLCODE -138`SUBSTR argument out of range](https://wndsoftware.com/mainframe-errors/sqlcode-138) - [`SQLCODE -150`Operation not allowed on this view or table](https://wndsoftware.com/mainframe-errors/sqlcode-150) - [`SQLCODE -151`Column cannot be updated](https://wndsoftware.com/mainframe-errors/sqlcode-151) - [`SQLCODE -171`Invalid argument to a function](https://wndsoftware.com/mainframe-errors/sqlcode-171) - [`SQLCODE -180`Invalid date, time or timestamp string](https://wndsoftware.com/mainframe-errors/sqlcode-180) - [`SQLCODE -181`Date or time value out of range](https://wndsoftware.com/mainframe-errors/sqlcode-181) - [`SQLCODE -199`Illegal use of a keyword](https://wndsoftware.com/mainframe-errors/sqlcode-199) - [`SQLCODE -203`Ambiguous column reference](https://wndsoftware.com/mainframe-errors/sqlcode-203) - [`SQLCODE -204`Undefined object name](https://wndsoftware.com/mainframe-errors/sqlcode-204) - [`SQLCODE -205`Column not in the named table](https://wndsoftware.com/mainframe-errors/sqlcode-205) - [`SQLCODE -206`Column name not valid](https://wndsoftware.com/mainframe-errors/sqlcode-206) - [`SQLCODE -208`ORDER BY column not in result table](https://wndsoftware.com/mainframe-errors/sqlcode-208) - [`SQLCODE -30081`Communication error detected](https://wndsoftware.com/mainframe-errors/sqlcode-30081) - [`SQLCODE -30082`Connection failed for a security reason](https://wndsoftware.com/mainframe-errors/sqlcode-30082) - [`SQLCODE -301`Input host variable type can't be used](https://wndsoftware.com/mainframe-errors/sqlcode-301) - [`SQLCODE -302`Input value invalid or too large](https://wndsoftware.com/mainframe-errors/sqlcode-302) - [`SQLCODE -303`Output variable type not compatible](https://wndsoftware.com/mainframe-errors/sqlcode-303) - [`SQLCODE -304`Value out of range for host variable](https://wndsoftware.com/mainframe-errors/sqlcode-304) - [`SQLCODE -305`Null value with no indicator variable](https://wndsoftware.com/mainframe-errors/sqlcode-305) - [`SQLCODE -310`Decimal host variable holds non-decimal data](https://wndsoftware.com/mainframe-errors/sqlcode-310) - [`SQLCODE -311`Input host variable length not valid](https://wndsoftware.com/mainframe-errors/sqlcode-311) - [`SQLCODE -312`Host variable not defined or not usable](https://wndsoftware.com/mainframe-errors/sqlcode-312) - [`SQLCODE -313`Host variables do not match parameter markers](https://wndsoftware.com/mainframe-errors/sqlcode-313) - [`SQLCODE -401`Operands not comparable](https://wndsoftware.com/mainframe-errors/sqlcode-401) - [`SQLCODE -404`String too long for the column](https://wndsoftware.com/mainframe-errors/sqlcode-404) - [`SQLCODE -406`Derived numeric value out of range](https://wndsoftware.com/mainframe-errors/sqlcode-406) - [`SQLCODE -407`Null value in a NOT NULL column](https://wndsoftware.com/mainframe-errors/sqlcode-407) - [`SQLCODE -408`Value not compatible with target type](https://wndsoftware.com/mainframe-errors/sqlcode-408) - [`SQLCODE -413`Overflow during numeric conversion](https://wndsoftware.com/mainframe-errors/sqlcode-413) - [`SQLCODE -420`String argument not acceptable to function](https://wndsoftware.com/mainframe-errors/sqlcode-420) - [`SQLCODE -421`Set operands have different column counts](https://wndsoftware.com/mainframe-errors/sqlcode-421) - [`SQLCODE -433`Value too long](https://wndsoftware.com/mainframe-errors/sqlcode-433) - [`SQLCODE -440`No routine with compatible arguments](https://wndsoftware.com/mainframe-errors/sqlcode-440) - [`SQLCODE -444`User program could not be found](https://wndsoftware.com/mainframe-errors/sqlcode-444) - [`SQLCODE -471`Routine invocation failed](https://wndsoftware.com/mainframe-errors/sqlcode-471) - [`SQLCODE -501`Cursor not open](https://wndsoftware.com/mainframe-errors/sqlcode-501) - [`SQLCODE -502`Cursor already open](https://wndsoftware.com/mainframe-errors/sqlcode-502) - [`SQLCODE -503`Column not in the cursor's FOR UPDATE list](https://wndsoftware.com/mainframe-errors/sqlcode-503) - [`SQLCODE -504`Cursor name not declared](https://wndsoftware.com/mainframe-errors/sqlcode-504) - [`SQLCODE -507`Cursor not open for UPDATE or DELETE](https://wndsoftware.com/mainframe-errors/sqlcode-507) - [`SQLCODE -508`Cursor not positioned on a row](https://wndsoftware.com/mainframe-errors/sqlcode-508) - [`SQLCODE -514`Cursor not in a prepared state](https://wndsoftware.com/mainframe-errors/sqlcode-514) - [`SQLCODE -516`DESCRIBE names an unprepared statement](https://wndsoftware.com/mainframe-errors/sqlcode-516) - [`SQLCODE -518`EXECUTE names an invalid prepared statement](https://wndsoftware.com/mainframe-errors/sqlcode-518) - [`SQLCODE -530`Foreign key value has no parent](https://wndsoftware.com/mainframe-errors/sqlcode-530) - [`SQLCODE -532`Delete restricted by a foreign key](https://wndsoftware.com/mainframe-errors/sqlcode-532) - [`SQLCODE -538`Foreign key doesn't match parent key](https://wndsoftware.com/mainframe-errors/sqlcode-538) - [`SQLCODE -540`Table definition incomplete, missing index](https://wndsoftware.com/mainframe-errors/sqlcode-540) - [`SQLCODE -542`Key column allows nulls](https://wndsoftware.com/mainframe-errors/sqlcode-542) - [`SQLCODE -543`Delete blocked by a check constraint](https://wndsoftware.com/mainframe-errors/sqlcode-543) - [`SQLCODE -545`Row violates a check constraint](https://wndsoftware.com/mainframe-errors/sqlcode-545) - [`SQLCODE -551`Not authorized for the operation](https://wndsoftware.com/mainframe-errors/sqlcode-551) - [`SQLCODE -552`Missing privilege for the operation](https://wndsoftware.com/mainframe-errors/sqlcode-552) - [`SQLCODE -567`Bind authorization error](https://wndsoftware.com/mainframe-errors/sqlcode-567) - [`SQLCODE -577`Routine not allowed to modify data](https://wndsoftware.com/mainframe-errors/sqlcode-577) - [`SQLCODE -579`Routine not allowed to read data](https://wndsoftware.com/mainframe-errors/sqlcode-579) - [`SQLCODE -601`Object name already exists](https://wndsoftware.com/mainframe-errors/sqlcode-601) - [`SQLCODE -603`Duplicate rows block a unique index](https://wndsoftware.com/mainframe-errors/sqlcode-603) - [`SQLCODE -604`Invalid length, precision or scale](https://wndsoftware.com/mainframe-errors/sqlcode-604) - [`SQLCODE -607`Operation not allowed on this object](https://wndsoftware.com/mainframe-errors/sqlcode-607) - [`SQLCODE -612`Duplicate name](https://wndsoftware.com/mainframe-errors/sqlcode-612) - [`SQLCODE -624`Table already has a primary key](https://wndsoftware.com/mainframe-errors/sqlcode-624) - [`SQLCODE -679`Drop pending on the object](https://wndsoftware.com/mainframe-errors/sqlcode-679) - [`SQLCODE -007`Illegal character in the statement](https://wndsoftware.com/mainframe-errors/sqlcode-7) - [`SQLCODE -723`Error in a triggered SQL statement](https://wndsoftware.com/mainframe-errors/sqlcode-723) - [`SQLCODE -724`Too many levels of cascading](https://wndsoftware.com/mainframe-errors/sqlcode-724) - [`SQLCODE -802`Arithmetic overflow or divide by zero](https://wndsoftware.com/mainframe-errors/sqlcode-802) - [`SQLCODE -803`Duplicate key](https://wndsoftware.com/mainframe-errors/sqlcode-803) - [`SQLCODE -804`Error in the program's SQL input parameters](https://wndsoftware.com/mainframe-errors/sqlcode-804) - [`SQLCODE -805`Package not found in plan](https://wndsoftware.com/mainframe-errors/sqlcode-805) - [`SQLCODE -808`CONNECT not consistent with the first CONNECT](https://wndsoftware.com/mainframe-errors/sqlcode-808) - [`SQLCODE -811`More than one row returned](https://wndsoftware.com/mainframe-errors/sqlcode-811) - [`SQLCODE -812`Blank collection ID in CURRENT PACKAGESET](https://wndsoftware.com/mainframe-errors/sqlcode-812) - [`SQLCODE -817`Prohibited data change operation](https://wndsoftware.com/mainframe-errors/sqlcode-817) - [`SQLCODE -818`Timestamp mismatch between program and DBRM](https://wndsoftware.com/mainframe-errors/sqlcode-818) - [`SQLCODE -084`Unacceptable SQL statement](https://wndsoftware.com/mainframe-errors/sqlcode-84) - [`SQLCODE -840`Too many items in a select or insert list](https://wndsoftware.com/mainframe-errors/sqlcode-840) - [`SQLCODE -842`Connection already exists](https://wndsoftware.com/mainframe-errors/sqlcode-842) - [`SQLCODE -900`Not connected to a server](https://wndsoftware.com/mainframe-errors/sqlcode-900) - [`SQLCODE -901`System error, later statements can run](https://wndsoftware.com/mainframe-errors/sqlcode-901) - [`SQLCODE -904`Resource unavailable](https://wndsoftware.com/mainframe-errors/sqlcode-904) - [`SQLCODE -905`Resource limit exceeded](https://wndsoftware.com/mainframe-errors/sqlcode-905) - [`SQLCODE -906`Function disabled by a prior error](https://wndsoftware.com/mainframe-errors/sqlcode-906) - [`SQLCODE -909`Object deleted or altered](https://wndsoftware.com/mainframe-errors/sqlcode-909) - [`SQLCODE -911`Deadlock or timeout, rolled back](https://wndsoftware.com/mainframe-errors/sqlcode-911) - [`SQLCODE -913`Deadlock or timeout, not rolled back](https://wndsoftware.com/mainframe-errors/sqlcode-913) - [`SQLCODE -922`Authorization failure](https://wndsoftware.com/mainframe-errors/sqlcode-922) - [`SQLCODE -923`Connection not established](https://wndsoftware.com/mainframe-errors/sqlcode-923) - [`SQLCODE -924`Db2 connection internal error](https://wndsoftware.com/mainframe-errors/sqlcode-924) - [`SQLCODE -925`COMMIT not valid in IMS, CICS or RRSAF](https://wndsoftware.com/mainframe-errors/sqlcode-925) - [`SQLCODE -926`ROLLBACK not valid in IMS, CICS or RRSAF](https://wndsoftware.com/mainframe-errors/sqlcode-926) - [`SQLCODE -927`Language interface called without a connection](https://wndsoftware.com/mainframe-errors/sqlcode-927) - [`SQLCODE +304`Value out of range for host variable (warning)](https://wndsoftware.com/mainframe-errors/sqlcode-plus-304) - [`SQLCODE +394`Optimization hints used](https://wndsoftware.com/mainframe-errors/sqlcode-plus-394) - [`SQLCODE +445`Value has been truncated](https://wndsoftware.com/mainframe-errors/sqlcode-plus-445) - [`SQLCODE +802`Arithmetic exception (warning)](https://wndsoftware.com/mainframe-errors/sqlcode-plus-802) ### Working with Db2 errors Keep the SQLCODE, SQLSTATE, statement and diagnostic tokens together. Negative codes, warnings and not-found conditions need different handling. These guides primarily discuss Db2 for z/OS; platform differences are called out where relevant. [Browse all 494 error codes](https://wndsoftware.com/mainframe-errors/) · [WND Terminal’s offline code hints](https://wndsoftware.com/docs/code-hints) ### Use WND Terminal with your host system WND Software develops WND Terminal Emulator for mainframe, IBM i and UNIX access. For connection and keyboard features, see the [3270 terminal emulator](https://wndsoftware.com/3270-terminal-emulator) or [5250 emulator for IBM i](https://wndsoftware.com/ibm-i). [Explain this screen](https://wndsoftware.com/explain-this-screen) provides screen-specific assistance using the model endpoint and context permitted by IT; the reference article explains the code independently.