CREATE TABLE QUALIFIER.TABLE (EMP-N0 CHAR(6) NOT NULL, MANAGER CHAR(6)

How do I create a table MANAGER (EMP-NO, MANAGER) where
MANAGER is a foreign key which references to EMP-NO in the
same table? Give the exact DDL.

Question Posted / s

3 Answers
6801 Views
I also Faced
E-Mail Answers

Answer Posted / s

CREATE TABLE QUALIFIER.TABLE
(EMP-N0 CHAR(6) NOT NULL,
MANAGER CHAR(6) NOT NULL)
IN TABLESPACE;

ALTER TABLE QUALIFIER.TABLE
FOREIGN KEY FKM (MANAGER) REFERENCES QUALIFIER.TABLE
ON DELETE CASCADE;

Is This Answer Correct ?

1 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is syscat in db2?

984

What is the maximum number of columns in a db2 table?

1266

I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.

2049

What is the use of predicate?

1024

What is dpf in db2?

1088

What is meant by union and union all?

986

What is plan in cobol db2?

1112

What are foreign keys in db2?

1082

What is db2 optimizer?

1215

What is explain plan in db2?

967

what is db2 restart?

2134

Define buffer pool.

1032

What is buffer pool and list some of them?

1005

Which is faster delete or truncate?

1108

In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?

1025