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
6732 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

Is db2 a mainframe?

994

what is the responsibility of the construction superintendent

2096

What is load replace in db2?

948

What is the difference between dbm cfg and db cfg file in db2 ?

1493

What is a page in db2?

991

What is view db2?

1020

Can there be more than one cursor open for any program?

1139

File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?

2882

What is database reorganization?

1072

How do I create a view in db2?

982

What does db2 stand for?

967

How do you simulate the explain of an embedded sql statement in spufi/qmf?

1051

Explain db2.

1002

How to test SQL -911 error while developing COB-DB2 program

7476

Explain package in db2 and its advantages?

1158