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 condition checking in jcl? Is this possible?

1158


How to alter the parameters for the existing gdg?

1254


Explain dd statement in jcl?

1181


What is 'mounting' of volumes ? Is there anything that a programmer can do in it ? How to find currently mounted volume ?

2652


I have a cobol db2 program(PGM A) where other program (PGM B) will call this program and passes some 50 fields data to PGM A. PGM A has some layout in which it receives the data from PGM B. And this layout has been copied in the linkage section pf PGM A. After getting the data, PGM A writes the data in a flat file in the same layout which it receives from PGM B. PGM B is a simple COBOL pgm. Please provide a JCL to run these programs.

2405


How to pass data to a program that is coded in an exec statement?

1383


Explain the job statement in jcl?

1214


what is DSN in JCL and what are the parameters to declare the DSN?

1249


what is the resolution for sb37 error

9251


Must tape dataset definitions include vol=ser specifications?

1783


What is the function of //jcllib statement?

1377


How is a type of file defined in the jcl that executes the cobol program?

1241


If a (+1) generation dataset is created in the first step of a job, how can it be referenced in later steps of the same job for input?

1376


What do you understand by the term notcat 2 – gs?

1292


What are the parameter we cannot use in procedure?

1193