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 sqlcode -501
What is bind and rebind in db2?
What are the various isolation levels possible?
What's The Error Code For Unique Index Voilation?
What is the purpose of rollback and commit?
B37 abend during spufi?
What are the rules for db2 programming?
When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?
If anyone has IBM Certification Dumps pls forward to me & also let me know what are the Certification Codes that are available in DB2
What is sqlca’s maximum length?
What is release/acquire in bind?
What is ibm db2 used for?
What is dbrm? What it contains? When it will be created?
How to access db2 tables in mainframe?
Is db2 a programming language?