What is the syntax required for the creation of a cursor?
- 1 Answers
- 9054 Views
- I also Faced
- E-Mail Answers
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.
| Is This Answer Correct ? | 12 Yes | 1 No |
Post New Answer View All Answers
Give a brief description of db2 isolation levels?
What is dclgen in db2?
what is diffrence b/w file-aid tool and file-aid utility???
What is the use of dclgen in db2?
What is the connection string to connect to the DB2 Database ?
Is it possible using max on a char column?
Which component is used to execute the sql statements?
What is clone table?
What types of tables are there in the db2 database?
What are types of indexes?
What is nvl in db2?
What is dclgen (declaration generator)?
What is the clustering index in the db2 database?
How do you concatenate the firstname and lastname from emp table to give a complete name?
Define db2 and its databases?
