Interested to Buy Any Domain ? << Click Here >> for more details...
Do we need cursor for Count(*)?
- 4 Answers
- 9028 Views
- iGate, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / nak
No,Count(*) will give u the number of record in a table.
Ex: select Count(*) from EMP table where EMPNAME='sunil'
| Is This Answer Correct ? | 13 Yes | 1 No |
Answer / yaswanth
we will use cursors when we have situation like the query
returning multiple rows but in this case
select Count(*) from EMP table where EMPNAME='some' will
return only one row, i.e how many rows it found with
EMPNAME='some' eg:3 or 4 or 5 ... so there is no concept of
cursor here
| Is This Answer Correct ? | 9 Yes | 3 No |
Answer / shravan kumar.p
no need..
select count(*) from the emp.
it will give the total no of rows in a table..
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / sachin borase
select 8 from table fetch first 3 rows only
| Is This Answer Correct ? | 0 Yes | 5 No |
How do I import a csv file into db2?
If I have a view which is a join of two or more tables, can this view be updateable?
how can i pull up a query which was previously stored in qmf
For update of a row in cursors, when do we move value into host variable in cobol progrm? is it before open or before fetch ?
How to resolve -803 sql code in DB2?
How to find last record before record through SQLRPGLE?
For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.
What does it mean if the null indicator has -1, 0, -2?
Is it Possible to declare or create a cursor for UPDATE of table? If yes tell me how? If no Tell me why?
What is the use of commit in db2?
What is db2 bind process?
what is the process of precompiler?
COBOL 
