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
6860 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 are bind concepts in db2 cobol?

1096

What is a buffer in memory?

1059

What is a bind in db2?

1043

What is runstats and reorg in db2?

1305

How to access db2 tables in mainframe?

1055

What is a db2 table?

1018

What is with ur in db2?

1320

What is role in db2?

1109

What type of database is db2?

971

What is database alias db2?

1129

Hello All, We have requirment to Replace BMC Db2 Load product thru CA FAST LOADPlus product. Do anyone have JCL to for FAST LOADPLUS and what all are thing need to take in consideration.

2727

What is the syntax for FETCH in DB2 ?

1216

Explain the contention situations caused by locks?

1070

What is a Foreign Key?

1099

Is db2 a database?

979