What is the syntax required for the creation of a cursor?
9 August 2009
288 views
No Comment
(No Ratings Yet)
Loading ...EXEC SQL
DECLARE cur_name CURSOR for
SELECT col1,col2
FROM table1
WHERE col1 = search_condition
END-EXEC.
Popularity: unranked [?]
Related interview questions
- Create dynamic query with dynamic joins
- When is the results table for the query in a DECLARE CURSOR statement created?
- when does the sql statement gets executed when you use cursor in the application programming ?
- Can we declare DB2 HOST variable in COBOL COPY book?
- What is cursor stability?
Leave your response!
You must be logged in to post a comment.