Answer / srinivas chennareddy

Though the tables are stored logically in tables space and
physically all tables/table Spaces are stored in VSAM
files....so the ultimate pgysical storage of any database
object is a VSAM file.

Answer / amit

plan is nothing but executable form of sql statements and
formed by one or more dbrms, it is used for run the program,
without plan it will not run.

physically tables are stored in table space of data base.
but the information of table is tabulated in system
table 'sysibm.systable'

correct me if i am wrong

Answer / srinvias yadav

PLAN IS AN EXECUTABLE ONE.
I.E,
WHEN THE CONCEPT OF MAIN PROGRAM AND SUB PROGRAM IS THERE
THEN WE NEED PLAN.
IF THERE IS A SINGLE PROGRAM THEN PACKAGE IS EXECUTABLE ONE.
ALL THE DB2 FILES ARE SAVED IN TABLESPACES.

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  

---

is it compulsory commitment control in journal?

0 Answers   TCS,

---

What is the function of the Data Manager?

2 Answers  

---

How is the SUBSTR keyword used in sql?

1 Answers  

---

Explain the use of the WHERE clause?

1 Answers  

---

What is drop table?

0 Answers  

---

Which catalog tables contain authorization information?

1 Answers  

---

How do I delete a table in db2?

0 Answers  

---

What is ibm db2 connect?

0 Answers  

---

wht steps we need will coding cobol and db2 pgm ?

6 Answers   CGI,

---

For unmatched rows returned from an outer join, the column values in the other table are set to null e.g If A OUTER JOIN B returns some unmatched rows from A, the corresponding column values in B will be set to null. What can be done so that a null value is not displayed for these columns?

3 Answers  

---

can any one give the list of some important sql abend codes which r frequently asked in interviews?

2 Answers  

---