https://ideawaza.com/api.php?action=feedcontributions&feedformat=atom&user=217.52.250.0%2F24 2026-09-29T13:58:14Z User contributions MediaWiki 1.46.0 https://ideawaza.com/index.php?title=SQL_return_codes&diff=52421 2008-05-11T08:28:20Z

<p>217.52.250.50: /* Negative values (Errors) */</p> <hr /> <div>'''SQL return codes''' are used for the diagnosis of programming failures as a result of SQL calls by [[w:en:IBM DB2|DB2]] [[w:en:computer program|programs]]. An important feature of DB2 programs is the error processing. The error diagnostic containing the SQL return code is held in the field '''SQLCODE''' within the DB2 [[w:en:SQLCA|SQLCA]] block.<br /> <br /> == SQLCA == <br /> The SQL communications area (SQLCA) structure is used within the DB2 program to return error information to the [[w:en:application program|application program]]. This information in the SQLCA and the SQLCODE field is updated after every [[w:en:Application programming interface|<br /> API]] call for the SQL statement. <br /> <br /> == SQLCODE ==<br /> The SQLCODE field contains the SQL return code. The code can be zero (0), negative or positive.<br /> <br /> 0 means successful execution.<br /> <br /> Negative means unsuccessful with an error. <br /> An example is -911 which means a timeout has occured with a rollback.<br /> <br /> Positive means successful execution with a warning. <br /> An example is +100 which means no rows found.<br /> <br /> Here is a more comprehensive list of the SQLCODEs for DB2:<br /> <br /> <br /> <br /> === Zero (Successful) ===<br /> 0 Successful <br /> <br /> === Negative values (Errors) ===<br /> <br /> -102 String constant is too long.<br /> -117 The number of values in the INSERT does not match the number of columns.<br /> -180 Bad data in Date/Time/Timestamp.<br /> -181 Bad data in Date/Time/Timestamp.<br /> -199 Illegal use of the specified keyword.<br /> <br /> -204 Object not defined to DB2.<br /> -205 Column name not in table.<br /> -206 Column does not exist in any table of the SELECT.<br /> -216 Not the same number of expressions on both sides of the comparison in a SELECT . <br /> -224 FETCH cannot make an INSENSITIVE cursor SENSITIVE.<br /> -229 The locale specified in a SET LOCALE statement was not found.<br /> <br /> ''' -305 Null'''''''''Bold text'''''' indicator needed.<br /> -311 Varchar, insert or update. -LEN field with the right data length not set.<br /> <br /> -482 The procedure returned no locators.<br /> <br /> -501 Cursor not open on FETCH.<br /> -502 Opening cursor that is already open.<br /> -503 Updating column needs to be specified. <br /> -530 Referential integrity preventing the INSERT/UPDATE<br /> -532 Referential integrity (DELETE RESTRICT rule) preventing the DELETE.<br /> -536 Referential integrity (DELETE RESTRICT rule) preventing the DELETE.<br /> -545 Check constraint preventing the INSERT/UPDATE.<br /> <br /> -747 The table is not available.<br /> <br /> -803 Duplicate key on insert or update.<br /> -805 DBRM or package not found in plan.<br /> -811 More than one row retrieved in SELECT INTO.<br /> -818 Plan and program: timestamp mismatch.<br /> <br /> -904 Unavailable resource. Someone else is locking your data.<br /> -911 Deadlock or timeout. Rollback has been done.<br /> -913 Deadlock or timeout. No rollback.<br /> -922 Authorization needed.<br /> -927 The language interface was called but no connection had been made.<br /> <br /> === Positive Values (Warnings) ===<br /> +100 Row not found or end of cursor.<br /> +222 Trying to fetch a row within a DELETE statement.<br /> +223 Trying to fetch a row within an UPDATE statement.<br /> +231 FETCH after a BEFORE or AFTER but not on a valid row. <br /> +304 Value cannot be assigned to this host variable because it is out of range.<br /> +802 The null indicator was set to -2 as an arithmetic statement didn't work.<br /> <br /> ==External links==<br /> * A [http://www.theamericanprogrammer.com/programming/sqlcodes.shtml more extensive list] of the codes<br /> <br /> [[category:SQL]]</div>

217.52.250.50