Interested to Buy Any Domain ? << Click Here >> for more details...
when does the SQL statement gets executed when you use
cursor in the application programming ?
- 3 Answers
- 10492 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / mna
The process of using cursor is:
1. declare the cursor in working storage: You will write
the SQL query here
2. open the declared cursor : this is when the actual SQL
query is executed and the fetched rows are moved to the
cursor storage.
3. Fetch rows from cursor : Reading rows one by one on the
Cursor just like we read records from a sequential file
4. Close cursor : While fetching if we get an SQLCODE=+100
it is the end of the cursor just like we encounter eof
while reading records from a sequential file. Once this
condition is encountered we will close the cursor.
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
If anyone has IBM Certification Dumps pls forward to me & also let me know what are the Certification Codes that are available in DB2
What is view db2?
Suppose pgm A calling Pgm B .Pgm B has some Db2 program. at the time of compilation should plan and package will be created for both A and B or only B? What is the concept?
What is sqlca?
What is data manager?
Discuss about db2 bind?
Before you give the explain statement, what are the prerogatives?
What is db2 and what is the use of db2 optimizer?
How to find schema of a table in db2?
How does db2 sample database connect?
What is universal database?
Which isolation level provides maximum concurrency?
What happens in bind step in a db2 program?
can we view the access paths created by dbrm ? how ? thx
Differentiate between cs and rr isolation levels? Where do you specify them?
