If there is no row in Emp table with Ename as Raghava and
you run the below queries in SPUFI.
1.select Ename from EMP wher Ename = 'raghava'
2.Select count(*) from EMP where Ename = 'raghava'
What is SQLCODE shown up in SPUFI
Answer Posted / krishna
2)when using count(*) it give always sql code 0 only
1)depending upone the rows if rows are their give 0
if not give 100
Is This Answer Correct ? | 9 Yes | 0 No |
Post New Answer View All Answers
What is innodb buffer pool?
What is ibm db2 client?
I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.
What is the difference between cursor stability and repeatable read isolation levels?
What is host variable?
What is null value in db2?
What is data manager?
What are the prerogatives?
How do we specify index to include or not during bind process.
Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?
Mention some fields that are a part of sqlca.
Is schema the same as database?
How many types of page locks can be held in db2?
What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?
Can you tell me how can you find out the # of rows updated after an update statement?