Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between normal select query and
currosor
- 2 Answers
- 17464 Views
- Cap Gemini, TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / jagan
using select in embedded sql with where clause should fetch
only one row , but cursor can be used when we need more rows
to be retrieved one at a time.
In case more than one row is retrieved in a select clause it
will throw -811 sql error.
| Is This Answer Correct ? | 28 Yes | 5 No |
Answer / vinay srivastava
Normal select Query fetches all rows in one go while cursor
fetches one row at a time.
| Is This Answer Correct ? | 10 Yes | 17 No |
Write a query to extract first 5 characters of a name in the column Stud_Name?
What is a db2 collection?
What is netezza database?
Q3. How will you fetch duplicate values from a DB2 table?
What is the difference between drop table and delete table?
How to resolve SQL Code -310. The db table feild is declared as Decimal(7,2).
What is an asychronous write?
Is there any advantage to denormalizing DB2 tables?
What is copy book?
What is bind and rebind in db2?
In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?
What is a synonym ?
COBOL 
