what is the difference between normal select query and
currosor
- 2 Answers
- 16349 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 |
What is isolation level?
How do you simulate the EXPLAIN of an embedded SQL statement in SPUFI/QMF? Give an example with a host variable in WHERE clause)
AGGREGATE function support by DB2. A) SUM & AVG B) SUM, MIN & AVG C) SUM, MAX, AVG , MIN &COUNT D) NONE
i have one file having 100 of records? i want to display it like 20 records in one column and 20 records in another column total 40 records per page ? how ?
Where can you declare a cursor in a cobol-db2 program?
What is the maximum size of a char data type in db2?
Is it Possible to read from PS file and write it to database by using dynamic sql(execute immediate)
Define data page.
What is performance tuning db2?
What does an outer join do?
what are the SQL codes u freequently got?
What is access path in db2?
COBOL 
