Answer Posted / ankitha

when you start coding any DB2 pgms you should include SQLCA
and DCLGEN member in w-s section and perform activities of
coding which need to be processed in procedure division.
all statements should be scoped in EXEC SQL and END-EXEC scope
only and you should precompile, create package and plan, you
should run this pgm by using plan. these are the steps we
follow these days.
i this this will help you

What is the physical storage length of time data type?

1175

---

What is null indicator in db2?

1160

---

What is dbrm library?

1112

---

If anyone has IBM Certification Dumps pls forward to me & also let me know what are the Certification Codes that are available in DB2

2088

---

Explain what are the various isolation levels possible?

1092

---

can any one provide me the link for the db2 v7 & db2 v8 manual for Z/os? i need to know about the syntax of REORG in both versions & need to know the difference as well

2289

---

What are the full forms of spufi and dclgen and why are they used?

1136

---

is it compulsory commitment control in journal?

2518

---

Is schema the same as database?

1100

---

What is host variable?

1109

---

How to fetch the last row from the table in SQL (db2)?

1691

---

What is the use of db2?

1110

---

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.

3259

---

Discuss about db2 bind?

1148

---

How can you find out the # of rows updated after an update statement?

1154

---