in the CURSOR declare statement, if i am using an where clause and trying to compare the value with a host-varialble. EXEC SQL DECLARE C1 CURSOR FOR SELECT DEPTNO, DEPTNAME, MGRNO FROM DEPARTMENT WHERE ADMRDEPT = :ADM-DEPT Where would i need to provide value to this host-variable in the where clause. how could i pass value to this host-variable to check it.

2 Answers   iGate,

---

i tried to copy some records from microsoft excel to as-400 physical file through "Bosanova" emulation. Out of 14000 records only 12000 records copies and subsequently programe started to hang. Then, i closed the program forcefully. I did' under stand the problem. Also when i try to compile the physical file it is showing as "The file in use". How to overcome this problem?

0 Answers   TATA,

---

wht happens if we close cursor with cursor with hold option?

3 Answers   Valtech,

---

can any one provide me the link for the db2 v7 & db2 v8 manual for Z/os? i need to know about the syntax of REORG in both versions & need to know the difference as well

0 Answers  

---

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

1 Answers   IBM,

---

how to identify the pseudo conversation by seeing the program

2 Answers   DELL,

---

Before you give the explain statement, what are the prerogatives?

0 Answers  

---

What is release/acquire in bind?

0 Answers  

---

How to handle null values in db2

4 Answers  

---

Can a unique index have more than one null value? If not, what error code is given if an attempt is made to insert more than one null value?

3 Answers  

---

What is meant by explain?

0 Answers  

---

What is cursor stability?

1 Answers  

---