ChannelDB2

Brian
  • 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

Gift

Brian has not received any gifts yet

Give a Gift

 

Brian's Page

Profile Information

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

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
http://www-01.ibm.com/software/os/systemz/telecon/jan27/

Reduce costs, increase capacity & availability with DB2 Data Sharing! Feb 24, 2009
http://www-01.ibm.com/software/os/systemz/webcast/feb24/
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.

Roger
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 (http://www-128.ibm.com/developerworks/forums/forum.jspa?forumID=805).

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

© 2018   Created by channeldb2.   Powered by

Badges  |  Report an Issue  |  Terms of Service