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.

What is an alias?

3 Answers  

---

What are the contents of a DCLGEN?

4 Answers   MetLife,

---

Could you please let me no the query for below I have table name xyx under this there is column name called employee name which starts from 100th column ends 120th column,now i want to replace only column from 101 to 104 which contains ABCS to replace with PQRS for all records which comes beetween 101 to 104 ..how to write query for this..

1 Answers   HSBC,

---

How to solved 818 error

4 Answers   Keane India Ltd, Wipro,

---

I need to view the number of tables existing under one particular Owner. Is it possible? If so, pl give the SQL query for this?

0 Answers  

---

Where do you specify them?

0 Answers  

---

Can All Users Have The Privilege To Use The SQL Statement Select (DML)?

1 Answers  

---

Define predicate?

0 Answers  

---

What is the specific need of Plan and..where are the tables in DB2 are physically saved

3 Answers   Infosys,

---

in column y record abc.v abc.s xyz.j abc.h i wan only abc columns how to retrieve thi records

2 Answers   IBM,

---

Is db2 a database?

0 Answers  

---

How many clustering indexes can be defined for a table?

2 Answers  

---