DSXchange

Hi,

Please help me . I have a requirement like this I have to look to a table DB2 for xxx,yyy,zzz columms with input source file and if it matched then I need to filter by condition (validfromdate from inputfile =or <> validfromdate in db2 table)and I must write records to db2 table. And I need to write the records from the source file to the table if there are no matching xxx,yyy,zzz colummsin db2 table (failed lookup records to DB2 table). can I use a reject link connected to lookup so that I can catch the records that failed the lookup condition and Iam writing records to a transformer which satisfied the lookup condition and Iam giving a constraint in transformer as lkup_validfromdate=lkup_DatB(validfromdate) to filter records that match the lookup condition.

CAN I CATCH THE REJECTED RECORDS IN LOOKUP(THAT DOESNOT SATISFY LOOKUP CONDITION) IF NOT THEN HOW TO ACHIEVE.


Thanks,
Somaraju.

Somu

Yes, you can catch record/s doesn't match in the reject link.

Hi Rasi,

Thanks for your answer. But When Iam connecting a look up to a reject link. Reject link is not allowed unless input reference link failure property is set to reject. Iam having a sequential file connected to transformer and connected to lookup its a stream link and reference link is DB2 /UDB API stage I couldbot find any properties in that stage where should I have to give this reference failure property . Please help me

Thanks,
Somaraju

Somu

You can open the Lookup Stage Conditions dialog box by:

Double-clicking on the Condition: bar on a reference link.

Selecting Conditions from the background shortcut menu.

Clicking the Conditions toolbar button.

Selecting Conditions from the link shortcut menu.


Thanks

Hi Rasi,


I really appreciate you for helping me out. Thanks one more time for helping me to achieve my target



Thanks,
Somu.