Answer / s

DB2 Precomplier comments out the SQL statments and replaces
with CALL statements to DB2. It places the consistency
token in both the DBRM and modified source program.

Answer / gouri

dsnhpc

Request to database but database is not available so what is was abend is raised?

2 Answers   UST,

---

What is the function of logging in the db2 database?

0 Answers  

---

How would one remove old reorg information from the DB2 catalog?

2 Answers  

---

What does reorg do in db2?

0 Answers  

---

How to define the data items to receive the fetch items for the SQL?

2 Answers  

---

What is meant by repeatable read?

4 Answers  

---

What is DCLGEN ?

2 Answers  

---

Is db2 a database?

0 Answers  

---

Hi , I am posting some interview ques . what is the use of cursors ? what is the diff between select and cursor ? bith are used for data retrival .. rite?

2 Answers   Deloitte,

---

If I have 5 Queries in a DB2 Cobol program , while precompiling how many DBRMs will get created and How many Plans and Packages will get created while Bind Process?

8 Answers   Accenture,

---

If there is no row in Emp table with Ename as Raghava and you run the below queries in SPUFI. 1.select Ename from EMP wher Ename = 'raghava' 2.Select count(*) from EMP where Ename = 'raghava' What is SQLCODE shown up in SPUFI

4 Answers   ADP,

---

where will u check for sqlcode ?

2 Answers   TCS,

---