Interested to Buy Any Domain ? << Click Here >> for more details...
What is the cascade rule and how does it relate to
deletions made with a subselect?
- 1 Answers
- 5566 Views
- I also Faced
- E-Mail Answers
Answer Posted / s
Cascade deletes the foreign keys when the primary key is
delted.
When using subselect the rows deleted are based on the rows
that qualify for the subselect.
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
How to get the ddl of a table in db2?
What is temporal table in db2?
What is the reason behind not using select * in embedded sql programs?
What is commit in db2?
What is a db2 cursor?
Suppose pgm A calling Pgm B .Pgm B has some Db2 program. at the time of compilation should plan and package will be created for both A and B or only B? What is the concept?
Mention the different locking levels that are available in db2.
How to find the number of rows in a db2 table?
What is the use of runstats in db2?
What does db2 plan contain?
What is page size in db2?
Comment whether dclgen is mandatorily used. If not, then what is the point of using it?
run jcl for cobol+db2 pgm?.. //jobcard //step001 exec pgm=ikjeft01 //systin dd * DSNSYSTEM(--------) RUN PROGRAM(MYPGMNAME) PLAN(-----), LIB(-------), PARMS(------) /* WHAT WILL U GIVE INSIDE THE BRACKETS... WHAT IS PLAN,PACKAGE,BIND?..PLAN N PACAKGES ARE GENERATED BY ?...
Explain what are the various isolation levels possible?
Explain about rct in db2?
