Interested to Buy Any Domain ? << Click Here >> for more details...
Select empno, sal from emptbl where empno < 101.By this
query can we fetch first 100 recs? where empno is primary
key.It won't throw -811 error? if it wont,then what is use
of cursor technique while fetching first 100 recs.
Please need more clarification.
- 2 Answers
- 6253 Views
- I also Faced
- E-Mail Answers
Answer Posted / kingmanish
Yes this query will fetch multiple records.
If tried to fetch these records in variables in a sql query
it will give -811 error.
In order to be able to handle these multiple records we
have to use cursor.
Now using cursor we can process each of these records one
at a time and thus cursors come handu here.
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
What does a deadlock mean in DB2?
what is the responsibility of the construction superintendent
Hi Everyone... Under the Logical files, when am working on multiple rec format logical file, I have joined two pf's using the multiple record format logical file concept, but when i run queried the LF only the first mentioned pf records are reflecting and I am not able to see any of the field records specified under the second pf. Kindly let me know whats the reason behind this. Below is the str of LF., R rec PFILE(LOGICAA) CUSTNO CUSTNAME BILL K CUSTNO R rec1 PFILE(LOGICAA1) CUSTNO ADD K CUSTNO .....
How to check table size in db2 sap?
What does db2 plan contain?
What are the various data types available in db2?
What kind of database is db2?
What do you mean by between and in? Is between inclusive of specified range values?
What is meant by dclgen?
What is image copy in db2?
Explain dclgen.
When do you specify the isolation level?
What is the difference between cursor and select statement?
Explain about rct.
What is dbrm? What it contains? When it will be created?
