Answer Posted / prabhu

by using dfhmdi macro we can design map
dfhmdi means datafacility highrar key map definition
syntax
mapname dfhmdi size=(24,80),
line=1,
column=1

can all users have the privilage to use the sql statement select * (dml)?

1144

---

Give the name of some fields form sqlca.

1057

---

Mention the definition of cobol in varchar field.

1226

---

What is a collection in db2?

1018

---

What is the default page size of buffer pools?

1108

---

What is the maximum number of columns in a db2 table?

1266

---

What is phantom read in db2?

1134

---

How to view db2 table structure?

1001

---

Mention the various locks that are available in db2.

1024

---

What is the advantage in De-normalizing tables in DB2?

1150

---

What is the physical storage length of date data type?

1233

---

What is the difference between cursor and select statement?

1080

---

What is check constraint. Explain with example.

1084

---

What is buffer pool and list some of them?

1006

---

How does db2 sample database connect?

1012

---