DSXchange

Hi Craig,

I did what you said, i have marked them as keys in the output DB2 stage and wrote a custom sql statement

Delete from <tablename> where col =? Colb = 2008 and colc = 'c' and cold='d'.

but it still not deleting those rows ..

thanks

Hi I have job requirement in which i have to delete some rows in the target before inserting into the target table depending on combination of key and nonkey coloumns. in target i have 22 coloumns in which 3 are key coloumns.i have to delete the rows in the target depending on 4 coloumns of which 2 ...

Hi

Can you give the solution for your problem .How did you solved it,I think it is usefull for me.

Thanks

Welcome to the forum! The biggest mistake that can be made in a posting is to mark it as urgent. The people who are responding are not paid to respond and marking it as urgent will probably get a slower response than you would have received without this urgent designation. I don't see a problem wit...

Hi I am new to this forum and this is my first post.If any mistakes forgive me. We are palnning to migrate our whole project from Datastage 7.5.2 EE to Datastage information server 8.0 We are thinking to import and export our jobs to migrate from older version to newer version. Is this the correct w...