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
10007 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

List down the types of triggers in the db2 database?

976

How do you select a row using indexes in db2?

1081

What is ibm db2 used for?

1016

What is the use of commit in db2?

1012

What is nvl in db2?

1052

Which is faster delete or truncate?

1079

Explain in brief how does db2 determine what lock-size to use?

977

How does db2 sample database connect?

979

Explain the function of data manager.

999

Why select is not preferred in embedded sql programs?

1247

what is a corelated subquerry?

1075

What is a plan and package in db2?

1055

Name the various locking levels available?

1049

before altering a table is it necessary to lock ? if lock what is it ? how to do ? ifi want to lock a table what is that command ?

2132

Where can you declare a cursor in a cobol-db2 program?

1011