How to connect to db2 database from windows command line?

0 Answers  

---

What is dynamic SQL?

1 Answers   ADP,

---

What is a Cartesian product?

2 Answers  

---

What is an alias?

3 Answers  

---

we can code COPY DCLGEN or INCLUDE DCLGEN, At which stage of the precompilation , dclgen get expanded if we write 1) copy 2) include one question about dclgen.. Is it mandatory to use declare table in dclgen.. I think no...but it will be used by the precompiler to validate the table name,column name etc.., can one clear my doubt ..is it necessary to include declare table or not?

2 Answers  

---

DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?

0 Answers  

---

What is reorg in database?

1 Answers  

---

While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?

0 Answers   JPMorgan Chase,

---

why should we bind the DB2 program . What if we did not BIND a BD2 program ??

9 Answers   Infosys, TCS, Xansa,

---

select * from orders where odate between '2010-01-01'and '2010-03-31' How do u fetch this into cursor?

2 Answers  

---

Assuming that a site's standard is that pgm name = plan name, what is the easiest way to find out which Will precompile of an DB2-COBOL program bomb, if DB2 is down?

1 Answers  

---

Give some example of statistics collected during RUNSTATS?

1 Answers  

---