Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 6852 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
How to rename a table in DB2 ?
How do I connect my db2 database to ibm?
How to create db2 table in mainframe?
How do you stop a db2 database in linux?
What is a db2 package?
What are the bind parameters ibm db2?
What is sqlca’s maximum length?
Define data page.
Which command is used to remove all rows from a table?
What is bind and rebind in db2?
If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?
What is bind package and plan in db2?
What is db2 and what is the use of db2 optimizer?
Hi Everyone... Under the Logical files, when am working on multiple rec format logical file, I have joined two pf's using the multiple record format logical file concept, but when i run queried the LF only the first mentioned pf records are reflecting and I am not able to see any of the field records specified under the second pf. Kindly let me know whats the reason behind this. Below is the str of LF., R rec PFILE(LOGICAA) CUSTNO CUSTNAME BILL K CUSTNO R rec1 PFILE(LOGICAA1) CUSTNO ADD K CUSTNO .....
When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?
