Answer / s

SQLCA is a collection of variables that is updated after
the execution of the SQL statment.
The values in these variables tells if the SQL completed
successfully or not and for testing specific error
conditions.

SQLCODE, SQLSTATE, SQLERRD(3)

what is difference between random and sequence file access

1 Answers   Syntel,

---

What is package versioning? Please give an example.

1 Answers  

---

In cursor program perform para varying until 1 by 1 fetch para cursor------close para in the blank what will come for confirming in the database?

1 Answers   HCL,

---

How do you do the EXPLAIN of a dynamic SQL statement?

2 Answers  

---

wht is d/f b/w inner join and outer join ? d/f group by and order by having by ?

2 Answers  

---

---

pls tell me abt the normalization five types....

2 Answers  

---

the dd name for ksds is dest1 and what is the dd name for alternate index of ksds ? a.dest b.dest1 c.dest1a d.dd1

2 Answers   Logica CMG,

---

What is the difference between using bind () and rebind () methods of naming class?

0 Answers  

---

How to compare data between two tables in db2?

0 Answers  

---

What are the 2 sqlcodes that are returned?

0 Answers  

---

What is concurrency in db2?

1 Answers  

---

why db2 is called as universal database?what is the storage capacity of db2v9 n what are the advantages of db2

3 Answers  

---