Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Cascade Update 1

Status
Not open for further replies.
RobtAR

RobtAR

Technical User
Aug 14, 2002
1
US
Being a newbie to DB2; I was hoping that someone could explain if the Cascade feature could apply to an UPDATE, i.e., that UPDATE in the parent table could automatically UPDATE any occurances of that column in the children tables?
 
Sort by date Sort by votes
Rob,

I'm afraid this doesn't apply. Perhaps you should consider using a trigger or stored procedure to do this.

Greg
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

gdg1976
  • Locked
  • Question
update subselect
Replies
0
Views
245
gdg1976
gdg1976
MichaelDe
  • Locked
  • Question
SQL Update with File Join
Replies
10
Views
975
MichaelDe
MichaelDe
evr72
  • Locked
  • Question
Update field from one table with a join table
Replies
1
Views
201
evr72
evr72
eaglei22
  • Locked
  • Question
DB2 Update coolumn based off of results from join?
Replies
1
Views
153
eaglei22
eaglei22
Rod41
  • Locked
  • Question
Problem on DB2 Update Table
Replies
6
Views
154
mikrom
mikrom

Part and Inventory Search

Sponsor

Back
Top