Answer Posted / 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.

Explain correlated sub-queries.

1010

---

How do you stop a db2 database in linux?

993

---

Comment whether the cursor is closed during commit or not.

1081

---

Is db2 a mainframe database?

978

---

What is bind package and plan in db2?

1043

---

What is the physical storage length of date data type?

1234

---

What is the use of db2 optimizer?

1087

---

Outputs of explain are with matchcols = 0. What does this signify?

1042

---

How to check last update on table in db2?

1039

---

What is db2 and what is the use of db2 optimizer?

1034

---

How can we retrieve the total number of records in RPG & CLLE?

631

---

Mention data types used in db2 ?

1142

---

What is a db2 table?

990

---

How do I import data from excel to db2?

1054

---

What is the maximum size of varchar data type in db2?

1116

---