Interested to Buy Any Domain ? << Click Here >> for more details...
What is the syntax required for the creation of a cursor?
- 1 Answers
- 9886 Views
- I also Faced
- E-Mail Answers
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.
| Is This Answer Correct ? | 12 Yes | 1 No |
What is the command used by TSO users to invoke DB2?
difference between group clause and order clause
What is dbrm? What it contains? When it will be created?
what's the equivalent Cobol Data type for Decimal(x,y) in DB2? what does the current SQLID register contain?
3 Answers Cap Gemini, Tech Mahindra,
What is difference between alias and synonym in db2?
What is an intent lock?
What is collection in db2 bind?
How to know the primary key of a table without defining the primary key in the table?
Explain about open switch business continuity software?
What is innodb buffer pool?
Update command
what is + sign and -ve sign for sql code ?
COBOL 
