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
- 9988 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
Why cursor is used in db2?
What is the max length of sqlca?
Mention the location where the output received from explain statement is stored.
Explain what are the various isolation levels possible?
While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?
Explain the function done by data manager?
Which command is used to connect to a database in DB2 ? Give the Syntax.
Is schema the same as database?
What is the syntax for seeing the columns and data types of a table in the db2 database?
what is the sqlcode -501
What are host variables in db2?
Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?
What is the role of schema in the db2 database?
What does db2 plan contain?
What is a cursor in programming?
