What is the self-referencing constraint?

Answer Posted / s

Self-referencing constraint makes the table both the parent
and dependent table in the same referential constraint. The
foreign key to the table is defined after the table is
created.

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

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 ?...

3796


What are types of indexes?

594


in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?

1628


What is the maximum size of varchar data type in db2?

646


what are bind concepts in db2 cobol?

652






What is the clustering index in the db2 database?

586


Define predicate?

645


What is the physical storage length of the data types date, time, and timestamp?

612


What type of database is db2?

526


What is bind and rebind in db2?

652


What is db2?

743


Explain about cursor stability?

624


Are views updateable?

647


How to execute stored procedures?

623


How can you classify the locks in db2?

636