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 / ekalavya
In Both the cases it's ZERO.
| Is This Answer Correct ? | 1 Yes | 15 No |
Post New Answer View All Answers
What is the difference between plan and package in db2?
Give a brief description of db2 isolation levels?
What types of tables are there in the db2 database?
What is a db2 schema?
What do you mean by cursor?
Why cursor is used in db2?
What is bufferpool in db2?
What is schema in db2?
Explain db2.
What is the use of dclgen in db2?
Explain about mirror activator disk mirroring?
What is innodb buffer pool?
Define check constraint.
What is buffer pool in the db2 database?
When reorg is used?