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.

What do you mean by commit and rollback?

1032

---

What is db2 look?

1018

---

What is declare cursor?

1111

---

run jcl for cobol+db2 pgm?.. //jobcard //step001 exec pgm=ikjeft01 //systin dd * DSNSYSTEM(--------) RUN PROGRAM(MYPGMNAME) PLAN(-----), LIB(-------), PARMS(------) /* WHAT WILL U GIVE INSIDE THE BRACKETS... WHAT IS PLAN,PACKAGE,BIND?..PLAN N PACAKGES ARE GENERATED BY ?...

4298

---

How to access db2 tables in mainframe?

1051

---

Explain the contention situations caused by locks?

1066

---

Which component is used to execute the sql statements?

1094

---

define clustering index.

1019

---

What is the maximum length of sqlca?

1519

---

How do I change the column size in db2?

1151

---

What is the use of reorg in db2?

1079

---

What is the reason behind not using select * in embedded sql programs?

1106

---

How do I import a csv file into db2?

984

---

What is meant by union and union all?

1006

---

Define db2 and its databases?

1053

---