In both case, It will show SQLCODE +100. As No row found condition is sati

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

Question Posted / raghavan.jcs

4 Answers
10174 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

Please Help Members By Posting Answers For Below Questions

What is reorg?

1160

What is runstats and reorg in db2?

1304

What is the usage of open cursor command?

1100

How do I import data from excel to db2?

1072

How do you simulate the explain of an embedded sql statement in spufi/qmf?

1090

Give a brief description of db2 isolation levels?

1072

Mention the different locking levels that are available in db2.

1134

What is a storage group (stogroup)?

1246

What is view db2?

1076

How to resolve deadlock issue

20122

List out the buffer pools in db2

1074

Is ibm db2 free?

1010

What is the cobol picture clause of the db2 data types date, time, timestamp?

1067

What are db2 objects?

1045

what is the role of the cursor in db2?

1067