what is SMP/E? and what are the major steps of it? thanks...

1 Answers   IBM,

---

How can you display the current date & current time ?

7 Answers   Cap Gemini,

---

How can you quickly find out the number of rows updated after an update statement?

1 Answers   CSI, CTS,

---

When would you prefer to use VARCHAR?

3 Answers  

---

have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.

0 Answers  

---

How many clustering indexes can be defined for a table?

2 Answers  

---

I am getting a error multiple row fetched while executing a Cobol-DB2 program.How can I solve it without using a cursor.

8 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 does a deadlock mean in DB2?

0 Answers  

---

How would the varchar column remarks defined?

0 Answers  

---

What is ibm db2 connect?

0 Answers  

---

in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?

0 Answers  

---