Originally posted by: coolmix

Hi,

I have a situation where I have to update a different set of columns in a table from different maps.

eg.

From map1: have to update column1, column2

From map2: have to update column9, column7

There will be multiple rows to be updated with different values. So I want to use the type tree for the table and set update columns in MDQ. 

Is there a way to do this without using different database definitions in the MDQ?

Thanks

Originally posted by: paul.brett

I would use multiple named views (all views pointing to the same table) so as to avoid having to have multiple database definitions in the MDQ file.

I can't think of any other way of doing this offhand.

Thank-you.

Paul

Follow me on Twitter