Code: Select all
DB2 table
| |
| |
----input data stream-->Lookup--target stream
|
|
reject file
input.key1=db2table.key1 based on condition Flag = OUT
input.key2=db2table.key2 based on condition Flag = IN
in lookup constraints I specified action as
Code: Select all
condition condition not met lokup on failure
--------- ------------------ ------------------
Flag = OUT continue continue
Flag = IN continue continue
lkp,0: Ignoring duplicate entry at table record 403958; no further warnings will be issued for this table
lkp,0: Ignoring duplicate entry at table record 403958; no further warnings will be issued for this table
1 does that mean it has two duplicate records?
And
2 how can i capcture those duplicate records in a file.
will reject file capcture duplicate records? OR rejected records OR both?