2)when using count(*) it give always sql code 0 only 1)depending upone the

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 / krishna

4 Answers
10170 Views
ADP, I also Faced
E-Mail Answers

Answer Posted / krishna

2)when using count(*) it give always sql code 0 only
1)depending upone the rows if rows are their give 0
if not give 100

Is This Answer Correct ?

9 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Explain the contention situations caused by locks?

1070

What is iseries database?

1046

What is explain plan in db2?

995

Explain in detail about buffer manager and its functionalities?

1064

What are packages in db2?

1023

Why do we bind in db2?

1210

What are iseries servers?

1075

Which is faster delete or truncate?

1127

What is copy pending and check pending in db2?

1002

Is db2 relational database?

979

Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?

3152

What r the comman abends in db2, jcl and cobol???????

2252

What is db2 command?

1035

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

1101

What are the 2 sqlcodes that are returned?

1187