What does runstats do in db2?

0 Answers  

---

I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?

0 Answers   HeadStrong,

---

how can you access index

4 Answers   IBM, Tech Mahindra,

---

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  

---

How to find the maximum value in a column in the db2 database?

0 Answers  

---

---

What is db2 bind process?

0 Answers  

---

What is dbrm library?

0 Answers  

---

How to check sequence on a table in db2?

0 Answers  

---

What is the picture clause of the null indicator variable?

6 Answers  

---

What is an EXPLAIN in DB2. How and what is the steps followed in EXPLAIN command. Can all the queries be used in EXPLAIN command to check the performance.

3 Answers   IBM,

---

What is the physical storage length of the data types: date, time, timestamp in the db2 database?

0 Answers  

---

how can i pull up a query which was previously stored in qmf

3 Answers  

---