• Male
  • IL
  • United States
Share on Facebook Share on Facebook Share

Brian's Friends

  • Rodolfo
  • Surekha Parekh
  • Conor O'Mahony
  • Saumitra

Brian's Groups

Brian's Discussions

MQT usage on z/OS
7 Replies

Started this discussion. Last reply by Vishal Kumar Dec 20, 2011.

Gifts Received


Brian has not received any gifts yet

Give a Gift


Brian's Page

Profile Information

Full Name:
Brian Boberg
Job Title:
Application Database Analyst
Don't care to say
Platforms of Interest:

Brian's Blog

Question concening dependencies with DB2 triggers

Posted on May 6, 2009 at 2:36pm 0 Comments

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

Comment Wall (6 comments)

You need to be a member of ChannelDB2 to add comments!

Join ChannelDB2

At 8:55am on February 25, 2009, agatha said…
Hi Brian, the link is broken because authorization to the DB2 wiki is needed for that link. I will remove it to avoid confusion. Thanks for letting me know.
At 5:47am on January 22, 2009, Surekha Parekh said…
No problem - please you can join. Please let me know if you require any additional information after the event.
At 6:28am on January 13, 2009, Surekha Parekh said…
Hi Brian, I am the the DB2 for z/OS Market Manager - we have 2 new web events coming up in Jan & Feb - please feel free to register. Here are the URLs
1. Business Benefits of DB2 Stored Procedure & Web 2.0; Jan 27, 2009

Reduce costs, increase capacity & availability with DB2 Data Sharing! Feb 24, 2009
At 8:28am on October 8, 2008, Roger E. Sanders said…
Hi Brian,

I did not see your reply - thanks. I just posted a follow-up to your comments.

At 12:16am on July 17, 2008, Raul said…
Hi Brian,

Thanks for the explanation. One simple/cheap solution would be to create a centralized internal Wiki with control from a few administrators from which all table/column definitions are stored. But sorry, I don't know of any industry best practices to handle this problem. There are many forums where you can post this question. You could start with the DB2 Express-C forum (

Good luck! Raul.
At 2:20am on July 16, 2008, Raul said…
Hi Brian,

Sorry for the late reply. As you stated "Data dictionary scope is too broadly defined"... so I would need more information as to what exactly you want to do.

Thanks for watching the videos!... I hope they are useful.

Cheers, Raul.

Featured Downloads

Try BLU Acceleration on Cloud

© 2021   Created by channeldb2.   Powered by

Badges  |  Report an Issue  |  Terms of Service