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
10372 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 about cursor stability?

1112

What is the difference between bind and rebind in db2?

1513

What is explain plan in db2?

1052

What is precompiler in db2?

1080

What is the physical storage length of time data type?

1181

What db2 400?

1260

What are types of indexes?

1190

What is load utility in db2?

1232

In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?

1096

What is the purpose of using commit?

1153

what is the sqlcode -501

13310

Explain the benefits you can get from mainframe connect?

1018

How many types of page locks can be held in db2?

1092

i want to maintain uniqueness on pdf without make lf??????????

2205

What is the difference between cursor and select statement?

1153