Brian's Blog (1)

Question concening dependencies with DB2 triggers

I am about to added two columns to a table named PROCESSED_LINE. The columns currently exist on a table named MKT_CNTRY. I realize I could do a JOIN between these two tables, but one of the JOIN columns contains a size mismatch (MKT_CNTRY.PART_NUMBER CHAR(12) and PROCESSED_LINE.SHIP_PROD_ID CHAR(18)).

Anyway, I would like to duplicate the two columns to the PROCESSED_LINE table and maintain them over time with a trigger on the MKT_CNTRY table (the master table).

I should… Continue

Added by Brian on May 6, 2009 at 2:36pm — No Comments

Monthly Archives


Featured Downloads

Try BLU Acceleration on Cloud

© 2019   Created by channeldb2.   Powered by

Badges  |  Report an Issue  |  Terms of Service