You could use two update statements or use a trigger.
Please take a few minutes to provide feedback on the quality of service you received from our staff. The Department of Education values your feedback as a customer. Commissioner of Education Dr. Eric J. Smith is committed to continuously assessing and improving the level and quality of services provided to you.Simply use the link below. Thank you in advance for completing the survey.
http://data.fldoe.org/cs/default.cfm?staff=Ed.[Email address protected]
-----Original Message-----
From: Gaurav Raj
[mailto:db2udbdba-ezmlmshield-x37661615.[Email address protected]
Sent: Thursday, January 24, 2008 12:58 PM
To: LazyDBA Discussion
Subject: FW: cascade update
Regards,
Gaurav Raj| APAC| Tech Mahindra
A-7, Sector 64, NOIDA, UP, Pin : 201303, INDIA
Cell: 9953138624
Email: gaurav.[Email address protected]
www.techmahindra.com
________________________________
From: Gaurav Raj
Sent: Thursday, January 24, 2008 11:26 PM
To: '[Email address protected]
Subject:
Hi ,
My question is "is there any method for automatic updation of value in
child table if there is any updation in master table on the value which
is used as reference key.............
Regards,
Gaurav Raj| APAC| Tech Mahindra
A-7, Sector 64, NOIDA, UP, Pin : 201303, INDIA
Cell: 9953138624
Email: gaurav.[Email address protected]
www.techmahindra.com
========================================================================
====================================================
Disclaimer:
This message and the information contained herein is proprietary and
confidential and subject to the Tech Mahindra policy statement, you may
review the policy at <a
href="http://www.techmahindra.com/Disclaimer.html">http://www.techmahind
ra.com/Disclaimer.html</a> externally and <a
href="http://tim.techmahindra.com/Disclaimer.html">http://tim.techmahind
ra.com/Disclaimer.html</a> internally within Tech Mahindra.
========================================================================
====================================================
---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
DB2 & UDB email list listserv db2-l LazyDBA home page