Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 4 Answers
- 10019 Views
- ADP, I also Faced
- E-Mail Answers
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 commit & rollback? When and where is used while compiling a cobol-db2 program?
What error I will get if my select query gives multiple row while executing a Cobol-DB2 program.How can I solve it without using a cursor.
4 Answers Cap Gemini, Verizon,
What are the various locks available?
define clustering index.
What is reorg and runstats in db2?
What kind of database is db2?
Why do we use cursor?
how does the defining of a stored procedure effect the size of a DB2 data base A) it increases the size of a data base B) it decreases the size of a data base C) it does not effect the size of the data base D) it changes the table space structures
What is a recovery log?
How can you compare table column after update and before update?
wt is view ? wht r the restrictions for view ?
How to know the primary key of a table without defining the primary key in the table?
COBOL 
