IBM DB2 Question:

What is the self-referencing constraint?

IBM DB2 Interview Question
IBM DB2 Interview Question

Answer:

A31. The self-referencing constraint limits in a single table the changes to a primary key that the related foreign key defines. The foreign key in a self referencing table must specify the DELETE CASCADE rule.


Previous QuestionNext Question
Is DECLARE CURSOR executable?A user
defined name that is the anchor for packages. It has not physical existence. Main usage is to group packages.

In SPUFI suppose you want to select max. of 1000 rows , but the select returns only 200 rows.