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
- 6212 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
Which component is used to execute the sql statements?
Mention the location where the output received from explain statement is stored.
How connect db2 database to datastage?
What is lock escalation in db2?
How does coalesce work?
Is db2 relational database?
Explain db2.
How do I import data from excel to db2?
When the like statement is used?
What is meant by dclgen?
What is precompiler in db2?
What are iseries servers?
Can you use max on a char column?
run jcl for cobol+db2 pgm?.. //jobcard //step001 exec pgm=ikjeft01 //systin dd * DSNSYSTEM(--------) RUN PROGRAM(MYPGMNAME) PLAN(-----), LIB(-------), PARMS(------) /* WHAT WILL U GIVE INSIDE THE BRACKETS... WHAT IS PLAN,PACKAGE,BIND?..PLAN N PACAKGES ARE GENERATED BY ?...
What is the maximum size of varchar data type in db2?
