Answer / s

Read-only cursor is a cursor that is defined with FOR FETCH
ONLY clause. The curosor is defined with SELECT, SELECT
INTO.

how 2 resolve the -311 sqlcode

1 Answers  

---

What is the default page size of buffer pools?

0 Answers  

---

What is normalization and what are the five normal forms?

1 Answers  

---

What is the physical storage length of the data types date, time, and timestamp?

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  

---

What is the use of commit in db2?

0 Answers  

---

Is it Possible to declare or create a cursor for UPDATE of table? If yes tell me how? If no Tell me why?

1 Answers   IBM, scintel,

---

When one binds a PACKAGE ( of a plan ) what package information is stored and where it is stored?

3 Answers  

---

What is the maximum number of columns in a db2 table?

0 Answers   IBM,

---

what is sql abend code -801,-802?

2 Answers  

---

What is the difference between SYNONYM and ALIAS?

6 Answers   TCS,

---

Can I use LOCK TABLE on a view?

1 Answers  

---