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 / 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 the difference between oracle and db2?
What is nvl in db2?
What is dbrm? What it contains? When it will be created?
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 ?
In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?
How to get the ddl of a table in db2?
What is concurrency?
What is ibm db2 client?
How to connect to db2 database from windows command line?
What is innodb buffer pool?
How do I import a csv file into db2?
What are the contents of dclgen?
What is the picture clause of null indicator variable?
What is node in db2?
What is the difference between spufi and qmf?