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

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 the sqlcode -501

12213


What is bind and rebind in db2?

909


What are the various isolation levels possible?

888


What's The Error Code For Unique Index Voilation?

921


What is the purpose of rollback and commit?

845


B37 abend during spufi?

1239


What are the rules for db2 programming?

900


When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?

3351


If anyone has IBM Certification Dumps pls forward to me & also let me know what are the Certification Codes that are available in DB2

1820


What is sqlca’s maximum length?

922


What is release/acquire in bind?

892


What is ibm db2 used for?

844


What is dbrm? What it contains? When it will be created?

819


How to access db2 tables in mainframe?

835


Is db2 a programming language?

820