Answer / krish

Bulk loading can be done using File-Aid DB2.

Answer / srini

Thru SPUFI/QMF/FileAID you can insert bulk records by
selecting the records from one table and inserting into
other one.

What is normalization and what are the five normal forms?

1 Answers  

---

what is rebinding ?

1 Answers   IBM,

---

If a non-DB2 program calls a DB2 program, the calling program's name will be there in SYSIN of IKJEFT01 and the plan name will be that of the called program. But is a bind needed or a plan has to be created for the non-DB2 program also?

1 Answers   RBS,

---

Explain dclgen.

0 Answers  

---

What is query for your birthday date should be in hours,minute and seconds format?

1 Answers   Fidelity,

---

For Null indicator we have 3 values 0,-1,-2. 0->Not nulll -1->Null -2->Value truncated If ther is any possibility to have any positive value other than 0 in Null indicator.If it is so then when we will get and what is the value?

1 Answers   BNP Paribas,

---

If we keep the DCLGEN structure for a table in a copybook and include it in the COBOL program using the COPY statement, will there be any impact during compilation or at any stage of program execution?

2 Answers  

---

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  

---

explain about index with examples

2 Answers   Syntel,

---

In a DB2-CICS program which is acts as co-ordinator and which is participant?

1 Answers   IBM,

---

What is the purpose of the WHENEVER statement?

1 Answers  

---

What are catalog tables in db2?

0 Answers  

---