Answer / nahid gorji

DB2 catalogs store MetaData , which means Data about Data.
Such as information about the DB2 objects created/Altered
by users or output of RUNSTATS utility which are utilized
when running SQL statement or selecting access path.

Answer / s

DB2 stores information about all the ojects in the db2
subsystem in the catalog tables.

How to retrieve rows from a db2 table in embedded sql?

0 Answers  

---

EXPLAIN has output with MATCHCOLS = 0. What does it mean?

2 Answers  

---

What is the syntax for creating a table in the db2 database?

0 Answers  

---

in the CURSOR declare statement, if i am using an where clause and trying to compare the value with a host-varialble. EXEC SQL DECLARE C1 CURSOR FOR SELECT DEPTNO, DEPTNAME, MGRNO FROM DEPARTMENT WHERE ADMRDEPT = :ADM-DEPT Where would i need to provide value to this host-variable in the where clause. how could i pass value to this host-variable to check it.

2 Answers   iGate,

---

If a table has a column "dept" (declared to have nulls) and there are 10 rows in the table of which 3 have a null value in the dept column, what will select count(*) and select count(distinct dept) return?

6 Answers  

---

if one db2 pgm calls another db2 pgm. how many plans do we need. what r the steps involved..

4 Answers   IBM,

---

What is the difference between Where and Having Clause

7 Answers   IBM, iFlex,

---

What does db2 blu stand for?

0 Answers  

---

What is meant by isolation level?

3 Answers  

---

can any body explain about plan and pakage in detail....

2 Answers   HSBC, IBM,

---

What information is held in SYSIBM.SYSCOPY?

1 Answers  

---

Can DB2 be accessed by TSO users? If yes, which command is used to invoke DB2?

1 Answers  

---