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

What is a page in db2?

980

What is the function of logging in the db2 database?

1069

What is load utility in db2?

1130

What is db2 command?

963

Can you use max on a char column?

1027

What is syscat in db2?

950

What is runstats and reorg in db2?

1237

What are the 2 sqlcodes that are returned?

1129

What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?

1114

What is the picture clause of null indicator variable?

1081

What is the physical storage length of time data type?

1064

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

1025

What do you mean by rollback?

932

What is the difference between spufi and qmf?

1053

What is package in cobol db2?

1076