Answer Posted / s

Isolation level can be specified at BIND time using the
ISOLATION parameter or in the SQL statement using the WITH
clause

WITH UR;

What are the various data types available in db2?

1012

---

Comment whether dclgen is mandatorily used. If not, then what is the point of using it?

1005

---

what is a corelated subquerry?

1063

---

in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?

2022

---

What is runstats and reorg in db2?

1237

---

Explain about cursor stability?

982

---

What is meant by explain?

1062

---

Define db2.

1064

---

Explain packages.

1055

---

What is the max length of sqlca?

1157

---

What is the difference between cursor stability and repeatable read isolation levels?

1115

---

What is the cobol picture clause of the db2 data types date, time, timestamp?

1009

---

What is dbrm? When it will be created?

957

---

What is the syntax for seeing the columns and data types of a table in the db2 database?

1086

---

How would the varchar column remarks defined?

1036

---