Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between normal select query and
currosor
- 2 Answers
- 17477 Views
- Cap Gemini, TCS, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
How to compare data between two tables in db2?
What is the physical storage length of time data type?
How can the firstname and the lastname from the emp table be concatenated to generate complete names?
How to take backup of table in db2?
in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?
What is the physical storage length of timestamp data type?
How can you validate Sql errors during cursor operation in db2 pgms and where do you code?
What is dbrm? What it contains? When it will be created?
Can we insert update delete in view?
How can you classify the locks in db2?
What are foreign keys in db2?
What type of database is db2?
Is the primary key a clustered index?
How can the duplicate values be eliminated from db2 select?
What is dbrm? What it contains?
