In a Microsoft Host Integration Server 2010 environment, you try to provoke an SQL error message. When the error message includes more than one diagnostic value in the SQL Communication Area (SQLCA), the Microsoft OLE DB Provider for DB2 parameters are not populated correctly.
For example, when you try to provoke SQLCODE -803, the SQL error message may resemble the following:
However, the SQL error message SQLCODE -803 should resemble the following:
For example, when you try to provoke SQLCODE -803, the SQL error message may resemble the following:
AN INSERTED OR UPDATED VALUE IS INVALID BECAUSE INDEX IN INDEX SPACE XPEI01?00001A6E04 CONSTRAINS COLUMNS OF THE TABLE SO NO TWO ROWS CAN CONTAIN DUPLICATE VALUES IN THOSE COLUMNS. RID OF EXISTING ROW IS X''
However, the SQL error message SQLCODE -803 should resemble the following:
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 IS X record_id