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
- 9275 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
How to execute stored procedures?
What is the use of reorg in db2?
What is load utility in db2?
What os does db2 run on?
What's The Percentage Free Space ?
Is db2 relational database?
Can you tell me how can you find out the # of rows updated after an update statement?
What is alias in db2?
What is consistency token in db2?
What is null indicator in db2?
What do you mean by storage group (stogroup)?
List down the types of triggers in the db2 database?
Are view updateable?
What is the use of dclgen in db2?
What are the various data types available in db2?
