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
- 6266 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / madhu t
If the to fetch empno and sal from emptble is written in
embedded sql then it will give sqlcode -811.
yes this query fetches first 100 records of employee table.
| Is This Answer Correct ? | 3 Yes | 1 No |
What are the bind parameters ibm db2?
What is deadlock?
Can i insert bulk records into a db2 table using qmf of spufi only............!!!
what is the differences between spufi and qmf and which is better?
4 Answers Accenture, Cap Gemini,
i have cobol+ db2 program but it contains n number of subprograms for this how many dbrm members i need to mention in bind process
How to select the duplicate rows from a table?
suppose in my table 10 rows are there , i want to update odd rows salary as 90000 ? how u do it ? any one help me ? what do we use here cursor-fetch or normal sql ?
What is a synonym? How is it used?
My SQL is not performing well. Describe how will you fine tune it?
What is ibm db2 connect?
What is normalization and what are the five normal forms?
What is referential integrity?
COBOL 
