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

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

4 Answers
10360 Views
ADP, I also Faced
E-Mail Answers

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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

When the like statement is used?

1280

What is the use of reorg in db2?

1137

If I have a view which is a join of two or more tables, can this view be updateable?

1184

Mention the definition of cobol in varchar field.

1315

How does a cursor work?

1040

How to rename a table in DB2 ?

1145

What is difference between isnull and coalesce?

1106

what is utility for parm lib

2419

what is db2 restart?

2213

Why select is not preferred in embedded sql programs?

1350

What is with ur in db2?

1384

What is release/acquire in bind?

1162

What does db2 plan contain?

1087

What type of database is db2?

1019

Mention the way of highlighting as well as putting a cursor to use in a cobol program.

1133