Answer / s

Lock is a DB2 structure used to ensure data integrity when
applications, utilities, commands are all accessing the
same data.

Could anyone clearly explain the diference between sub query and correlated sub query?

3 Answers  

---

wht steps we need will coding cobol and db2 pgm ?

6 Answers   CGI,

---

What are the 4 environments which can access DB2 ?

2 Answers  

---

What is node in db2?

0 Answers  

---

query to just fetch first matching row and stop execution. once one matching row is found ..no more records should be checked.. if the first record is matching.. the query must stop

2 Answers   IBM,

---

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,

---

what is copy pending and check pending ?

1 Answers   Xansa,

---

Plan is an executable form of sql statements,But what exactly resides inside a Plan. what are the details inside Plan.

2 Answers   IBM,

---

What is a clustering index ?

3 Answers  

---

Once you create a view, where would information about the view be stored?

1 Answers  

---

Where can you declare a cursor in a cobol-db2 program?

0 Answers  

---

How do I connect my db2 database to ibm?

0 Answers  

---