If a non-DB2 program calls a DB2 program, the calling program's name will be there in SYSIN of IKJEFT01 and the plan name will be that of the called program. But is a bind needed or a plan has to be created for the non-DB2 program also?

1 Answers   RBS,

---

what is the difference between join and union?

4 Answers   IBM,

---

What is the use of with ur in db2?

0 Answers  

---

What information is held in SYSIBM.SYSCOPY?

1 Answers  

---

what is difference between Plan and Package

1 Answers   Syntel,

---

Can there be more than one cursor open for any program?

0 Answers  

---

What is consistency token in db2?

0 Answers  

---

What parameters are used to control the free space in DB2?

0 Answers  

---

What is concurrency?

0 Answers  

---

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  

---

Give the COBOL definition of a VARCHAR field.

2 Answers  

---

What is a db2 schema?

0 Answers  

---