When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?

0 Answers   Broadridge,

---

Can we use group-by clause in sub-query? If 'yes' means,Will it be executed successfully or else If 'no' means why should we not using that method? Give me your suggestion please....

1 Answers  

---

What is the logical entity between plan and Package?

5 Answers  

---

How to define the a field which accepts value till 99999.99 in db2

3 Answers  

---

Explain the use of the WHERE clause.

2 Answers   IBM,

---

can any one provide me the link for the db2 v7 & db2 v8 manual for Z/os? i need to know about the syntax of REORG in both versions & need to know the difference as well

0 Answers  

---

How to resolve -502 sql code in DB2?

2 Answers   Cap Gemini,

---

I have 1000 rows in a db2 table.I want to update first 100 records,How do I do it?

4 Answers   CTS,

---

What is an EXPLAIN in DB2. How and what is the steps followed in EXPLAIN command. Can all the queries be used in EXPLAIN command to check the performance.

3 Answers   IBM,

---

Once you create a view, where would information about the view be stored?

1 Answers  

---

How to insert more than one record using insert?

7 Answers   Atos Origin, IBM,

---

Mention the length of physical storage of the given data types of db2 – date, timestamp, time

0 Answers  

---