Answer / guest

the db2 variable can be declared in the working-storage
section by using the DCLGEN of the particular table.
Eg:
EXEC SQL
INCLUDE DCB0XXX
END-EXEC.

How to select the duplicate rows from a table?

4 Answers  

---

Can i insert bulk records into a db2 table using qmf of spufi only............!!!

2 Answers  

---

Why do we need to create an alias if we can directly use the table name? What are the benefits of referring a table name by its alias? Also, when should we go for alias and when for synonyms?

1 Answers  

---

what is consistency token

3 Answers  

---

My DB2 program first read the data from a file and then it look into a table with the data it got from the file.If we did not bind the program , should the file read before SQL execution be success??

2 Answers   Xansa,

---

Can a array declared with an index be displayed(readable format) in spool?

4 Answers   Syntel, UST,

---

how to resolve -805. give clear explination for that

2 Answers   IBM,

---

What is a LIKE table and how is it created?

2 Answers  

---

What are db2 tables?

0 Answers  

---

What is dynamic SQL?

1 Answers   ADP,

---

What is normalization and what are the five normal forms?

1 Answers  

---

Is it mandatory to use DCLGEN? If not, why would you use it at all?

2 Answers  

---