In both case, It will show SQLCODE +100. As No row found condition is sati

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

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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is meant by dclgen?

1061

What are catalog tables in db2?

981

How to find the number of rows in a db2 table?

1065

What is reorg?

1072

Are view updateable?

984

What is a cursor in programming?

1016

How do I import a csv file into db2?

938

Define buffer pool.

999

What are the 2 sqlcodes that are returned?

1131

List out the three types of page locks that can be held.

1093

What os does db2 run on?

929

Define check constraint.

1028

If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?

1093

What is a storage group (stogroup)?

1189

How do you concatenate the firstname and lastname from emp table to give a complete name?

1016