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
10022 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 meant by union and union all?

965

How to take backup of table in db2?

1032

can all users have the privilage to use the sql statement select * (dml)?

1127

What is rct?

1184

What is the physical storage length of time data type?

1079

What is multi row fetch in db2?

1003

Are views updateable?

1087

Mention a credible reason why select* is never given preference in an sql program that has been embedded.

1153

How to resolve deadlock issue

19932

How do you pull up a query which was previously saved in qmf?

1114

What are iseries servers?

1027

How do I delete a table in db2?

1027

What is dbrm library?

1016

What is runstats db2?

977

What os does db2 run on?

940