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
Explain the function of data manager.
What is a bind in db2?
How can the duplicate values be eliminated from db2 select?
What are the full forms of spufi and dclgen and why are they used?
What is the syntax for creating a table in the db2 database?
Is it possible to create an Instance in DB2 using DB2 Control Center ?
How do I import data from excel to db2?
What is the role of schema in the db2 database?
what is a corelated subquerry?
Is the primary key a clustered index?
Explain about rct.
Describe major components of db2?
On which levels locks can be applied?
How many types of page locks can be held in db2?
Explain various types of locks in db2?