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 use of dclgen in db2?
What is alias in db2?
What is difference between isnull and coalesce?
What is the maximum number of columns in a db2 table?
What is iseries database?
What is cursor stability in db2?
What is a collection in db2?
Name the various locking levels available?
I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?
File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?
What is role in db2?
What is ibm db2 connect?
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.
What is the use of with ur in db2?
What is the syntax for seeing the columns and data types of a table in the db2 database?