Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 4 Answers
- 10172 Views
- ADP, I also Faced
- E-Mail Answers
Answer Posted / guest
For 1st query the sql code will +100
for second query the count is zero and sql code is 0
| Is This Answer Correct ? | 30 Yes | 3 No |
Post New Answer View All Answers
What is nvl in db2?
What is load utility in db2?
Why do we use cursor?
Is the primary key a clustered index?
How and when does the db2 enforces the unique key?
Outputs of explain are with matchcols = 0. What does this signify?
How is the value function used?
Mention the different locking levels that are available in db2.
Explain what are the various isolation levels possible?
Where do you specify them?
Is schema the same as database?
Explain the benefits you can get from mainframe connect?
What action db2 takes when a program aborts in the middle of a transaction?
Is db2 a programming language?
What is sqlca’s maximum length?
