Answer / girish kumar

General copybook changes are adding new fields and change
the length of the fields.



Correct me if it is wrong.it just my idea.

How to resolve -502 sql code in DB2?

2 Answers   Cap Gemini,

---

How is the SUBSTR keyword used in sql?

1 Answers  

---

what is Static and dynamic linking

1 Answers   Virtusa,

---

What are the four lockable units for DB2?

1 Answers  

---

How to know the primary key of a table without defining the primary key in the table?

5 Answers   Satyam,

---

What is the maximum number of columns in a db2 table?

0 Answers   IBM,

---

In cursor program-1 can we create another cursor program-2 inside the cursor program-1.If yes how/no why ?

2 Answers   Wipro,

---

before altering a table is it necessary to lock ? if lock what is it ? how to do ? ifi want to lock a table what is that command ?

0 Answers   IBM,

---

Which component is responsible for db2 startup and shutdown?

0 Answers  

---

i have table agdet i want first 5 maximum commission which query will you write for this thanks in advance

3 Answers  

---

Where are plans stored?

2 Answers  

---

which is the most efficient tablespace?? a.simple tablespace. b.partitioned tablespace. c.segmented tablespace. d.none of the above. please post answer with the reason.?

3 Answers  

---