Answer / naveen87ginjupalli

SQLCODE, SQLERRM, SQLERRD.

What is cursor stability?

1 Answers  

---

In terms of DB2 indexing, what is the root page?

1 Answers  

---

I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.

0 Answers   ITC Infotech, Syntel,

---

What is the meaning of -805 SQL return code?

3 Answers  

---

how many partitions are possible in partitioned tablespace? dont say 1-64. a)240 b)256 c)512 d)none

8 Answers   Amdocs, HeadStrong,

---

---

Describe what a storage group(STOGROUP) is?

2 Answers  

---

What kind of database is db2?

0 Answers  

---

can we view the access paths created by dbrm ? how ? thx

2 Answers   IBM,

---

WHAT IS NULL INDICATOR ? WERE IS THIS USED? AND IF IT IS USED IN FILES CONCEPT? HOW DO WE USE IT?

2 Answers   IBM,

---

What is Reorg Recovery? when will you run it?

2 Answers  

---

What if we fail to give values in columns declared as NOT NULL ?

3 Answers   Cap Gemini,

---

What is a DBRM, PLAN ?

3 Answers  

---