Answer / s

Host Variables are data structures used to recieve column
values from the table.

Answer / praveen

host variable is db2 table equalent variable.

Answer / azharuddinsyed

Host variable is a cobol equivalent variable for a table column.

Hi Everyone... Under the Logical files, when am working on multiple rec format logical file, I have joined two pf's using the multiple record format logical file concept, but when i run queried the LF only the first mentioned pf records are reflecting and I am not able to see any of the field records specified under the second pf. Kindly let me know whats the reason behind this. Below is the str of LF., R rec PFILE(LOGICAA) CUSTNO CUSTNAME BILL K CUSTNO R rec1 PFILE(LOGICAA1) CUSTNO ADD K CUSTNO .....

0 Answers  

---

Explain an outer join?

1 Answers  

---

When do you specify the isolation level? How?

1 Answers  

---

How do you declare a host variable (in COBOL) for an attribute named emp-name of type VARCHAR(25) ?

2 Answers   IBM, Tech Mahindra,

---

What is a plan and package in db2?

0 Answers  

---

---

What is the significance of DB2 free space and what parameters control it?

1 Answers  

---

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

0 Answers  

---

how to u check the query is executing or not ?where will u check for sqlcode ?

6 Answers   Infosys,

---

What is PRIME TABLE and what are the uses of it

1 Answers  

---

What is an intent lock?

3 Answers  

---

How do I handle -911 (deadlock) error in a db2 program so that the program will never abend?

3 Answers   CTS, IBM,

---

How do I optimize a query in db2?

0 Answers  

---