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
- 10364 Views
- ADP, I also Faced
- E-Mail Answers
Answer Posted / raghavan.jcs
In both case, It will show SQLCODE +100.
As No row found condition is satisfied here
| Is This Answer Correct ? | 10 Yes | 12 No |
Post New Answer View All Answers
I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.
How can the firstname and the lastname from the emp table be concatenated to generate complete names?
Define db2 and its databases?
What is a system catalog table in db2?
What is runstats db2?
What is cascading rollback?
What is dbrm? What it contains? When it will be created?
What is phantom read in db2?
by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?
What is db2 and what is the use of db2 optimizer?
What are concurrency issues?
What is a db2 collection?
What is cursor stability in db2?
How can deadlocks be resolved?
What is the maximum size of varchar data type in db2?
