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


Please Help Members By Posting Answers For Below Questions

What is the difference between oracle and db2?

820


What is nvl in db2?

843


What is dbrm? What it contains? When it will be created?

816


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 ?

2109


In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?

872


How to get the ddl of a table in db2?

887


What is concurrency?

935


What is ibm db2 client?

711


How to connect to db2 database from windows command line?

822


What is innodb buffer pool?

778


How do I import a csv file into db2?

777


What are the contents of dclgen?

874


What is the picture clause of null indicator variable?

913


What is node in db2?

827


What is the difference between spufi and qmf?

843