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  

---

i know the stpes 2 create an executable CICS/DB2 cobol code. 1. DB2 Precompiler converts the SQL Statements into COBOL API statements and creates another member with Acess plans. CodeA results in CodeB (code with API calls) & CodeC ( Access Plans ) 2.Code B is compiled/linked 2 create an exceutable.(codeE) 3.Now CodeC is binded to the database on which CodeE will be run. Can somebody provide me the sample JCLs for precompile/compile/link/bind.

0 Answers  

---

Can you use a select query in a loop to fetch multiple rows? If so what is the advantage of using a cursor?

2 Answers   L&T, UST,

---

Hi Team, Please tell me, If i don't declare the cursor in the program and i have given open and fetch and close, then what error will get.

6 Answers   IBM,

---

What are the benefits of using the db2 database?

0 Answers  

---

Is db2 a mainframe database?

0 Answers  

---

What is with ur in db2?

0 Answers  

---

On which levels locks can be applied?

0 Answers  

---

In a DB2-CICS program which is acts as co-ordinator and which is participant?

1 Answers   IBM,

---

which SQL comment successfully removes uncommitted changes from a DB2 database A) rollback B) delete C) drop D) decommit

2 Answers   Accenture, Wipro,

---

Can any one tell me about Restart logic in DB2.

2 Answers  

---

What do you mean by storage group (stogroup)?

0 Answers  

---