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

How many sub queries can you combine together ?

4 Answers   IBM,

---

Can we use select * statement in cobol program without giving field names ???

3 Answers   Zensar,

---

what is the name of the default db2 catalog database?

3 Answers   IBM,

---

Which component is used to execute the sql statements?

0 Answers  

---

How do you filter out the rows retrieved from a Db2 table ?

1 Answers  

---

In BIND, isolation level parameter specifies the duration of page lock and ACQUIRE, RELEASE also do almost the same thing. What is the exact difference between the two? Do they work in conjunction while executing SQL queries and obtaining locks?

8 Answers   Syntel,

---

what is the certification that has a good value for a practioner in mainframes but not habving much knowledge on db2 related stuff?

2 Answers  

---

For unmatched rows returned from an outer join, the column values in the other table are set to null e.g If A OUTER JOIN B returns some unmatched rows from A, the corresponding column values in B will be set to null. What can be done so that a null value is not displayed for these columns?

3 Answers  

---

what is copy pending and check pending ?

1 Answers   Xansa,

---

How do you check for a null value in a db2 column?

2 Answers  

---

how to identify the pseudo conversation by seeing the program

2 Answers   DELL,

---

How do you run JCL in cobol program

1 Answers   IBM, Syntel,

---