Answer / guest

C) SUM, MAX, AVG , MIN &COUNT

Answer / ramakrishna nattam

c

Which DB2 catalog tables are used to produce a list of table column by table for all tables in a database?

1 Answers  

---

if there is a table with huge number of records and if i want to extract only first 3 records from the table, what query i have to provide to retreive first 3 records

4 Answers   UST,

---

what is different three logs in DB2?

1 Answers   Syntel,

---

What r the comman abends in db2, jcl and cobol???????

0 Answers   Mphasis,

---

What is an alias?

3 Answers  

---

How can you find out which query is taking lot of time to execute in cobol-db2 program ?

1 Answers   Danske,

---

What's the Maximum Length of SQLCA and what's the content of SQLCABC?

2 Answers  

---

What is the result of open cursor statement?

0 Answers  

---

What is a DBRM, PLAN ?

3 Answers  

---

in column y record abc.v abc.s xyz.j abc.h i wan only abc columns how to retrieve thi records

2 Answers   IBM,

---

How do I delete a table in database?

0 Answers  

---

In db2, how do you insert multiple rows in 1 query using a.) Cursors, b.) Normal query?? Give syntax for both.

5 Answers   CTS,

---