Answer / prasad

Example For cursor Syntax:

Declare Cursor:

EXEC SQL DECLARE CUST_ITM CURSOR
FOR
SELECT
OWN_CUS_NO,

OWN_CUS_ITM_SUF_NO
FROM
NPJXTII
WHERE SCK_NO = :SCK-
NO
AND SCK_DT = :NPS-ORIG-TRANS-
DT

AND SCK_LN_ITM_SEQ_NO = :SCK-LN-ITM-SEQ-
NO

END-
EXEC.

Open Cursor:

EXEC SQL OPEN CUST_ITM
END-EXEC.

Fetch Cursor:

EXEC SQL FETCH CUST_ITM
INTO :OWN-CUS-NO,
:OWN-CUS-ITM-SUF-NO
END-EXEC.


Close Cursor:

EXEC SQL CLOSE CUST_ITM
END-EXEC.

in GDG: is it poosible to copy records from a file which utilizes some 100 cylinders to a gdg whose model is defined as trk(1,0) and also it possible to copy 100 bytes file to 80 bytes file?

1 Answers   IBM,

---

Is there any advantage to denormalizing DB2 tables?

1 Answers  

---

What happens to the PLAN if index used by it is dropped?

1 Answers  

---

What is meant by explain?

0 Answers  

---

Q4. How will you get the count of record without using COUNT verb in query?

2 Answers   IBM,

---

my project is insurance management system,how to explain my work environment in interview?

2 Answers   CGI, Value Labs,

---

Hi Dude,this is Ram.could any one tell me aboue CURRENT OF clause in DB2. Thanks in advance.......

2 Answers  

---

Where are plans stored?

2 Answers  

---

How do I connect my db2 database to ibm?

0 Answers  

---

What is the meaning of -805 SQL return code?

3 Answers  

---

how 2 resolve the -311 sqlcode

1 Answers  

---

Describe what a storage group(STOGROUP) is?

2 Answers  

---