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
- 10150 Views
- ADP, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is the maximum size of varchar data type in db2?
What is the role of schema in the db2 database?
What is multi row fetch in db2?
What do you mean by commit and rollback?
What is buffer pool and list some of them?
define clustering index.
What is check constraint. Explain with example.
How do I optimize a query in db2?
For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.
How do you pull up a query which was previously saved in qmf?
What is the role of the data page in the db2 database?
What is the difference between cursor and select statement?
What is the reason behind not using select * in embedded sql programs?
What does db2 stand for?
What is the use of runstats in db2?
