Answer / 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

Is there any advantage to denormalizing DB2 tables?

1 Answers  

---

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

0 Answers   IBM,

---

Is Cursor exicutable ?

3 Answers   TetraSoft,

---

Write a query to retrive partial string.

2 Answers  

---

how can you save the query in QMF?IS IT POSSIBLE OR NOT.IF POSSIBLW HOW?

1 Answers   Hewitt,

---

---

what is SPUFI ?

2 Answers  

---

What is the use of predicate?

0 Answers  

---

I have a table which has thousand of records i want to fetch only record num 100 to record num 200. Write a query that satisfies this criteria.(Cant use any keys) Anyone please reply ASAP!

17 Answers   KNIT, Tech Mahindra,

---

What are the functions in DB2?

3 Answers   Satyam,

---

How to design maps

1 Answers   Virtusa,

---

quary for 1> fetch last record 2> fetch in reverse order 3> fetch last 5 row 4> fetch second last record (their is no primary key) i think concept of count can be use for this in 4th

5 Answers  

---

i have table agdet i want first 5 maximum commission which query will you write for this thanks in advance

3 Answers  

---