Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

delete rules in db2

Answer Posted / vinay sonar

There are 3 rules

PARENT TABLE CHILD TABLE

ON DELETE SET NULL DELETE SET NULL

ON DELETE CASCADE DELETE DELETE

ON DELETE RESTRICT DELETE NO CHANGE

Is This Answer Correct ?    13 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is the difference between JES3 and JES2?

1118


What are the rules employed while naming the steps in a job?

1134


what is use of dsn parameter in dd statement?

1146


Can we call instream to catalog and catalog to instream?

1123


In job processing, what happens in conversion stage?

1180


Is there any command to check wether the ps file is in sorted order?

2877


Immediate Job opening for mainframe professionals in Keane Bangalore. Please find the below details: Organization: Keane India Location: Bangalore Skill: COBOL, JCL,VSAM,DB2,CICS,IMS,REXX,CLIST Exp: 1 to 4 years only Employment Type: Permenant Employee Note: If you have attended keane interview in past 6 months please ignore this job opening. Please respond to email id keanemfjob@gmail.com OR keanemfjob@yahoo.in with your latest resume and following details, We will contact you within 24 hours: Total IT Exp: Exp in Mainframe: Current CTC: Expected CTC: Notice Period:

3977


what EXEC statement is and what is the syntax of EXEC statement used in JCL?

1148


why should SYSIN DD * statement should not be included inside a PROCedure snippet??? please answer this.. i need to know.

2436


What is the significance of addrspc parameter in exec statement?

1187


hello friends ,i have exam in Hsbc,pls any on send me placement papers and technical questions on mainframes,thank u

2134


Differentiate between the joblib and the steplib statements?

1413


Where can program checkpoints be stored for use in a restart?

1422


What are the parameter we cannot use in procedure?

1103


How can the attributes of one sms dataset be copied to another dataset?

1412