Category: DB2

IBM DB2 Error Code -803 – an inserted or updated value is invalid

In this post, you’ll learn about the IBM DB2 Error -803 and the reason why you are receiving it IBM DB2 Error Code : -803 Reason for this Error in DB2 AN INSERTED OR UPDATED VALUE IS INVALID BECAUSE THE INDEX IN INDEX SPACE indexspace-name CONSTRAINS COLUMNS OF THE TABLE SO NO TWO ROWS CAN CONTAIN DUPLICATE VALUES IN THOSE COLUMNS. RID OF EXISTING ROW…

IBM DB2 Error Code -20478 – the statement cannot be processed becau

In this post, you’ll learn about the IBM DB2 Error -20478 and the reason why you are receiving it IBM DB2 Error Code : -20478 Reason for this Error in DB2 THE STATEMENT CANNOT BE PROCESSED BECAUSE COLUMN MASK mask-name (DEFINED FOR COLUMN column-name) EXISTS AND THE COLUMN MASK CANNOT BE APPLIED OR THE DEFINITION OF THE MASK CONFLICTS WITH THE REQUESTED STATEMENT. REASON CODE…