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.
- 3 Answers
- 5926 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
What are the benefits of using the db2 database?
What is dclgen in db2?
For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.
What is dbrm? When it will be created?
What is a db2 tablespace?
what is the responsibility of the construction superintendent
Is ibm db2 free?
What is copy pending and check pending in db2?
In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?
What is null indicator in db2?
Explain about rct.
How do I import data from excel to db2?
What is the difference between plan and package in db2?
Suppose pgm A calling Pgm B .Pgm B has some Db2 program. at the time of compilation should plan and package will be created for both A and B or only B? What is the concept?
What do you mean by storage group (stogroup)?
