Tag: DB2 Errors

DB2 Error Code – -414 a like predicate is invalid because the first operand is not a string

DB2 Error Code – -154 the create view failed because the view definition contains a union, a union all, or a remote object

DB2 Error Code – -164 auth-id1 does not have the privilege to create a view with qualification

DB2 Error Code – -635 the delete rules cannot be different or cannot be set null

DB2 Error Code – -150 the object of the insert, delete, or update statement is a view for which the requested operation is not permitted

DB2 Error Code – -625 table table name does not have an index to enforce the uniqueness of the primary key

DB2 Error Code – -412 either remove the reference to current sqlid or the reference to the remote object.

DB2 Error Code – -684 the length of literal list beginning string is too long

DB2 Error Code – -538 foreign key name does not conform to the description of the primary key of table table name

DB2 Error Code – -627 the alter statement is invalid because the pageset has user managed data sets

DB2 Error Code – -802 exception error ‘exception type’ has occurred during ‘operation type’ operation on ‘data type’ data, position ‘position number’

DB2 Error Code – -667 the clustering index for a partitioned tablespace cannot be explicitly dropped

DB2 Error Code – -682 field procedure procedure name could not be loaded

DB2 Error Code – -113 invalid character found in name: name.

DB2 Error Code – -676 a 32k page bufferpool may not be used for an index

DB2 Error Code – -10 the string constant beginning with ‘string’ is not terminated

DB2 Error Code – -304 a value with data type data-type1 cannot be assigned to a host variable because the value is not within the range of the host variable in position position-number with data type data-type2

DB2 Error Code – -160 the with check option cannot be used for the specified view

DB2 Error Code – -204 name is an undefined name

DB2 Error Code – -531 the primary key in a parent row cannot be updated because it has one or more dependent rows in relationship constraint name