I have a table with a primary key that I am using "LOAD" sql to populate the table and use the "for exception <exception table>" to capture any incoming records that have redundant primary keys. The tables are identical in form except that the exception table has two additional columns: the next to last is a TIMESTAMP and the last is a CLOB(32K) as the documentation specifics in the rules for creating an exception table. Additionally there are no keys, constraints, triggers or any other encumbrances on the table. When I execute the "LOAD" statement I get the following error:
SQL3604N Exception table "test exception" corresponding to table
"test" in the SET INTEGRITY statement or LOAD utility does not have the
proper structure, has been defined with unique indexes, constraints, generated
columns, or triggers, or is in the Set Integrity Pending state, or is of
invalid type. Reason code "2". SQLSTATE=428A5
I've looked up the error in every source I can think of or find and basically just get what is in the message with the exception of what 'reason code "2"' means.
Any thoughts as to what I am doing wrong?
Thanks...
SQL3604N Exception table "test exception" corresponding to table
"test" in the SET INTEGRITY statement or LOAD utility does not have the
proper structure, has been defined with unique indexes, constraints, generated
columns, or triggers, or is in the Set Integrity Pending state, or is of
invalid type. Reason code "2". SQLSTATE=428A5
I've looked up the error in every source I can think of or find and basically just get what is in the message with the exception of what 'reason code "2"' means.
Any thoughts as to what I am doing wrong?
Thanks...