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
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / 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 |
Answer / raghavan.jcs
In both case, It will show SQLCODE +100.
As No row found condition is satisfied here
Is This Answer Correct ? | 10 Yes | 12 No |
What is the FREE command?
How can record locking be achieved in those DB2 versions which do not support it?
What are the Isolation levels possible ?
max number of columns in a db2 table?
AGGREGATE function support by DB2. A) SUM & AVG B) SUM, MIN & AVG C) SUM, MAX, AVG , MIN &COUNT D) NONE
what is the use of cursors?
What are the disadvantages of PAGE level lock?
Which component is responsible for db2 startup and shutdown?
What is consistency token in db2?
What do you do to keep the cursor from closing after a commit?
Which components manage deadlocks in db2?
What is the syntax for FETCH in DB2 ?