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 reason behind not using select * in embedded sql programs?

854


What is plan in cobol db2?

799


What do you mean by rollback?

755


What is a db2 tablespace?

790


Can you tell me how can you find out the # of rows updated after an update statement?

868


How can you count the number of rows from a table tab?

844


Is schema the same as database?

833


How do I create a view in db2?

794


What is a system catalog table in db2?

843


How to run db2 command in windows?

889


What is a db2 cursor?

811


What are the contents of dclgen?

854


What is release/acquire in bind?

873


What are the different types of base tables?

771


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

3334