Portal | IBM Manuals | Downloads | Products | Refer | Info | Programs | JCLs | Forum Rules*| Site Map | Mainframe CD 
IBMMAINFRAMES.com - IBM Mainframe Support Forums Index
 
Register
 
IBMMAINFRAMES.com - IBM Mainframe Support Forums Index FAQ Search Memberlist Usergroups Profile Log in to check your private messages Log in
 
db2 referential integrity

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> Interview Questions
Author Message
rambabu
Currently Banned
Active User


Joined: 18 Apr 2005
Posts: 67
PostPosted: Sat May 28, 2005 6:57 pm    Post subject: db2 referential integrity
 Reply with quote
there is a referrential integrity between the employee and db2 table.now i want to drop the object on employee table? is it possible?how ?please give the query?
Back to top
View user's profile Send private message
References
priya

Moderator


Joined: 24 Jul 2003
Posts: 624
Location: Bangalore
PostPosted: Sat May 28, 2005 10:24 pm    Post subject:
Reply with quote
Based on the constrain you have specified... CASCADE / SET NULL or RESTRICT?
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> Interview Questions All times are GMT + 6 Hours
Page 1 of 1