How to define the data items to receive the fetch items for the SQL?

2 Answers  

---

What is RUNSTATS?

3 Answers  

---

What is the use of db2 optimizer?

0 Answers  

---

cursor with hold explain ?

1 Answers   Verizon,

---

select distinct(empid),distinct(dept),name from EMP will the above query work?

2 Answers   CTS,

---

---

What is the role of the data page in the db2 database?

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  

---

How to create a table using embedded sql?

1 Answers  

---

Explain about cursor stability?

0 Answers  

---

what is the role of the cursor in db2?

0 Answers  

---

Write a query to extract first 5 characters of a name in the column Stud_Name?

1 Answers   RBS,

---

What is usage pointer in cobol?

3 Answers   IBM,

---