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
- 10371 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 ibm db2 used for?
What is a DB2 catalog?
How do you declare a host variable (in COBOL) for an attribute named emp-name of type VARCHAR(25) ?
What is check constraint in db2?
What is innodb buffer pool?
If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?
While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?
What does db2 plan contain?
What is the purpose of coding FETCH in a SQL SELECT query? Explain with an example in Detail?
If I have a view which is a join of two or more tables, can this view be updateable?
What is a root page?
if any of the column names is provided wrong, where do you get the error(during precompilation or during Bind)
COBOL 
