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
- 10195 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 |
List down the data types in the db2 database.
Discuss about db2 bind?
How do I start db2 in windows?
Parm value passed is PARM=(10,20). how do code linkage section and how would you add these two passes values and show result in cobol program.
What does DML stand for and what are some examples of it?
what is the responsibility of the construction superintendent
if i made sme changes in sub pgm wht r the things to be done for this ?
What is a clustering index ?
Mention the length of physical storage of the given data types of db2 – date, timestamp, time
How many types of page locks can be held in db2?
How to check sequence on a table in db2?
How is the SUBSTR keyword used in sql?
COBOL 
