If there is no row in Emp table with Ename as Raghava and you run the below qu

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
9977 Views
ADP, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

If there is no row in Emp table with Ename as Raghava and you run the below queries in SPUFI. 1..

Answer / guest

For 1st query the sql code will +100
for second query the count is zero and sql code is 0

Is This Answer Correct ?

30 Yes

3 No

If there is no row in Emp table with Ename as Raghava and you run the below queries in SPUFI. 1..

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

If there is no row in Emp table with Ename as Raghava and you run the below queries in SPUFI. 1..

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

If there is no row in Emp table with Ename as Raghava and you run the below queries in SPUFI. 1..

Answer / ekalavya

In Both the cases it's ZERO.

Is This Answer Correct ?

1 Yes

15 No

Post New Answer