Answer / s

Correlation names are used in the SQL statment as an
alternate name to a qualified table.

What is the physical storage length of each of the following DB2 data types: DATE, TIME, TIMESTAMP?

1 Answers   CTS,

---

What is the latest version of ibm db2?

0 Answers  

---

COBOL PRECOMPILER ERROR: "XXXXXX" (TABLE) PREVIOUSLY DECLARED OR REFERENCED DCLGEN VARIABLES GETS IMPORTED TWICE FOR ONLY ONE EXEC SQL STATEMENT. WHAT COULD BE THE PROBLEM?

1 Answers  

---

What is correlation names?

1 Answers  

---

The only place of VSAM KSDS in DB2 is?

2 Answers   IBM,

---

What DB2 Catalog column tell you when an index needs table reorganized ?

1 Answers  

---

What is the SQL query to select, delete and get count of duplicate rows in DB2?

2 Answers  

---

difference between group clause and order clause

1 Answers  

---

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?

2 Answers  

---

What statistic will tell the DBA how must space can be reclaimed from dropped table spaces on the next reorg run?

1 Answers  

---

What are the advantages of using a PACKAGE?

2 Answers  

---

What happens to a tablespace when its recovery infromation has been removed and a full recovery is no longer possible?

2 Answers  

---