The American Programmer. SQLCODES for SQL DB2 in MVS, OS3. ZOS SQLCODE codes Version 1. When running a program that uses SQL, DB2 gives you an SQLCODE that tells you whether your. SQL worked or not. Scroll down to see ALL the SQLCODES there are in Version 1. OgTuz.jpg' alt='How To Update A Null Value In Db2 Error' title='How To Update A Null Value In Db2 Error' />SQLCODES for DB2 Version 8. IBM manual GC1. 8 7. Scroll down, or use your browsers FIND to find the desired SQLCODE. The SQLCODES are not all in numerical order. Compliments of Gabe Gargiulo, author of several recent books on programming and modern languages. Amazon. com. SQLCODE 1. SQLSTATE 0. 20. 00 Row not found or end of cursor. SQLCODE 2. 22 Trying to FETCH a row that fell through a DELETE hole. SQLCODE 2. 23 Trying to FETCH a row that fell through an UPDATE hole. SQLCODE 2. 31 FETCH but you did a BEFORE or AFTER and you are not on a valid row. SQLCODE 3. 04 Value cannot be assigned to this host variable because it is out of range. TSQL Programming Part 7 Understanding How to Use the UPDATE Statement to Change Your Data. SQLCODE 8. 02 The null indicator was set to 2 because an arithmetic statement didnt work. SQLCODE 0. 00, successful execution. SQLCODE 0. 07 statement contains the illegal character character. SQLCODE 0. 10 the string constant beginning string is not terminated. SQLCODE 0. 11 comment not closed. SQLCODE 0. 12, warning the unqualified column name was interpreted as a correlated reference. SQLCODE 0. 29 INTO clause required. SQLCODE 0. 51 identifier name sql type was previously declared or referenced. SQLCODE 0. 56 an SQLSTATE or SQLCODE variable declaration is in a nested compound statement. SQLCODE 0. 57 the return statement in an sql function must return a value. SQLCODE 0. 58 value specified on return statement must be an integer. SQLCODE 0. 60 invalid specification type specification specification value. ABEND CODES ERROR CODES Mainframe forum Mainframe Mainframe IBM tutorial, tutorials, material, materilas, faq, faqs, interview questions, COBOL,CICS,DB2,JCL. Oxford Reading Tree New Trainers Activities there. COBOL, DB2, SQL, open cursor declare fetch, Embedded SQL, Model Program. Null or NULL is a special marker used in Structured Query Language to indicate that a data value does not exist in the database. Introduced by the creator of the. EF%82%A7+Consider+this+statement%3A.jpg' alt='How To Update A Null Value In Db2 Error' title='How To Update A Null Value In Db2 Error' />SQLCODE 0. SQLCODE 0. 79 qualifier for object name was specified as qualifier. SQLCODE 0. 84 unacceptable SQL statement. SQLCODE 0. 87 a null value was specified in a context where a null is not allowed. SQLCODE 0. 96 variable variable name does not exist or is not supported by the server and a default value was not provided. How To Update A Null Value In Db2 Error' title='How To Update A Null Value In Db2 Error' />SQLCODE 0. LONG VARCHAR or LONG VARGRAPHIC is not allowed in this context. SQLCODE 0. 98, warning a dynamic SQL statement ends with a semicolon. SQLCODE 1. 00, not found row not found for FETCH, UPDATE or DELETE, or the result of a query is an empty table. SQLCODE 1. 01 the statement is too long or too complex. SQLCODE 1. 02 String constant is too long copy right 2. The. American. Programmer. Unauthorized copying prohibited. SQLCODE 1. 03 constant is an invalid numeric constant. SQLCODE 1. 04 illegal symbol token. Some symbols that might be legal are token list. SQLCODE 1. 05 invalid string. SQLCODE 1. 07 the name name is too long. Maximum allowable size is size. SQLCODE 1. 08 the name name is qualified incorrectly. SQLCODE 1. 09 clause type clause is not permitted. SQLCODE 1. 10 invalid hexadecimal constant beginning constant. SQLCODE 1. 10, warning SQL UPDATE to a data capture table not signaled to originating subsystem. SQLCODE 1. 11, error a column function does not include a column name. The. American. Programmer. Unauthorized copying prohibited. SQLCODE 1. 11, warning the subpages option is not supported for type 2 indexes. SQLCODE 1. 12 the operand of an aggregate function includes an aggregate function, an OLAP specification, or a scalar fullselect. SQLCODE 1. 12, error the operand of a column function is another column function. SQLCODE 1. 13 invalid character found in string, reason code nnn. SQLCODE 1. 14 the location name location does not match the current server. SQLCODE 1. 15 a predicate is invalid because the comparison operator operator is followed by a parenthesized list. ANY or ALL without a subquery. SQLCODE 1. 17 The number of values you are trying to INSERT does not match the number of columns. SQLCODE 1. 18 the object table or view of the DELETE or UPDATE statement is also identified in a FROM clause. SQLCODE 1. 19 a column or expression in a HAVING clause is not valid. SQLCODE 1. 20 an aggregate function or OLAP specification is not valid in the context in which it was invoked. SQLCODE 1. 20, error a WHERE clause, SET clause, VALUES clause, or a SET assignment statement includes a column function. SQLCODE 1. 21 the column name is identified more than once in the INSERT or UPDATE operation or set transition variable statement. SQLCODE 1. 22 column or expression in the SELECT list is not valid. SQLCODE 1. 23 the parameter in position n in the function name must be a constant or keyword. SQLCODE 1. 25 an integer in the order by clause does not identify a column of the result. SQLCODE 1. 26 the SELECT statement contains both an UPDATE clause and an ORDER BY clause. SQLCODE 1. 27 DISTINCT is specified more than once in a subselect. SQLCODE 1. 28 invalid use of null in a predicate. SQLCODE 1. 28, error invalid use of null in a predicate. SQLCODE 1. 29 the statement contains too many table names. SQLCODE 1. 30 the escape clause consists of more than one character, or the string pattern contains an invalid occurrence. SQLCODE 1. 31 statement with LIKE predicate has incompatible data types. SQLCODE 1. 32 an operand of value is not valid. SQLCODE 1. 33 an aggregate function in a subquery of a having clause is invalid because all column references. SQLCODE 1. 34 improper use of a string, LOB, or XML value. SQLCODE 1. 36 sort cannot be executed because the sort key length too long. SQLCODE 1. 37 the length resulting from operation is greater than maximum length. SQLCODE 1. 38 the second or third argument of the substr or substring function is out of range. SQLCODE 1. 40. 3 the username andor password supplied is incorrect. SQLCODE 1. 42 the SQL statement is not supported. SQLCODE 1. 44 invalid section number number Copy right 2. The American Programmer. Unauthorized copying prohibited. SQLCODE 1. 47 ALTER function function name failed because source functions or spatial functions cannot be altered. SQLCODE 1. 48 the source table or tablespace source name cannot be altered or renamed, reason reason code. SQLCODE 1. 50 the object of the INSERT, DELETE, UPDATE, merge, or truncate statement is a view. SQLCODE 1. 51 the UPDATE operation is invalid because the catalog description of column column name. SQLCODE 1. 52 the DROP clause clause in the ALTER statement is invalid because constraint name is a constraint type. SQLCODE 1. 53 the statement is invalid because the view or table definition does not include a unique name for each column. SQLCODE 1. 54 the statement failed because view or table definition is not valid. SQLCODE 1. 56 the statement does not identify a table. SQLCODE 1. 57 only a table name can be specified in a foreign key clause. Object name is not the name of a table. SQLCODE 1. 58 the number of columns specified for name is not the same as the number of columns in the result table. SQLCODE 1. 59 the statement references object name which identifies an actual type rather than an expected type. SQLCODE 1. 60 the WITH CHECK OPTION clause is not valid for the specified view. SQLCODE 1. 60. 00 an xquery expression cannot be processed because the context component component. SQLCODE 1. 60. 01 an xquery expression starting with token token cannot be processed. SQLCODE 1. 60. 02 an xquery expression has an unexpected token token following text.