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.

when we are trying to update db2 rows. if the program abends . how we will know that the last successful update row was

5 Answers   IBM,

---

pls explain the precompilation process of cobol-db2 pgm

3 Answers   HCL, IBM,

---

how will i display the duplicate record's from a table... i don't want to eliminate ...i want to display the duplicate record...for example in my table i have 10 record's like record no(1,2,3,4,2,9,6,1) in this ...so i want to receive duplicates...

1 Answers   UST,

---

What is a data page?

1 Answers  

---

what is rebinding ?

1 Answers   IBM,

---

---

How do you retrieve the first 5 characters of firstname column of db2 table emp?

1 Answers  

---

Explain about dbrm.

0 Answers  

---

What is the difference between drop table and delete table?

0 Answers  

---

wht happens if we close cursor with cursor with hold option?

3 Answers   Valtech,

---

What does it mean if the null indicator has -1, 0, -2?

1 Answers  

---

What is the difference between nvl and coalesce?

0 Answers  

---

db2 maintains information about the data... a.in tables. b.in a set of tables known as db2 catalog. c.in db2 database. d.none of the above.

1 Answers  

---