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
What is the reason behind not using select * in embedded sql programs?
What is plan in cobol db2?
What do you mean by rollback?
What is a db2 tablespace?
Can you tell me how can you find out the # of rows updated after an update statement?
How can you count the number of rows from a table tab?
Is schema the same as database?
How do I create a view in db2?
What is a system catalog table in db2?
How to run db2 command in windows?
What is a db2 cursor?
What are the contents of dclgen?
What is release/acquire in bind?
What are the different types of base tables?
When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?