Interested to Buy Any Domain ? << Click Here >> for more details...
When Can you be sure that a query will return only one row?
- 4 Answers
- 8676 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / shailendra
when you will retrive the record on the basis of primary key
for the perticuler record.
as like
select * from table_name where acct_no =2345678754332
the above given answeris also right
| Is This Answer Correct ? | 2 Yes | 1 No |
Answer / s
A Matching Index scan with equal predicate on a Unique
index will return only one row.
| Is This Answer Correct ? | 1 Yes | 1 No |
Answer / shankar
When you use CURSORS in your program.
or
when you use FETCH FIRST (n) ROW ONLY option on your SELECT
statement.
| Is This Answer Correct ? | 1 Yes | 2 No |
Answer / shekhar
when u use column function without using group by clause. it will give only single value. PLz correct if i m wrong.
| Is This Answer Correct ? | 0 Yes | 2 No |
What is a db2 cursor?
What is lock contention?
Discuss about db2 bind?
How would one remove old reorg information from the DB2 catalog?
If I have a view which is a join of two or more tables, can this view be updateable?
What is meant by isolation level?
Explain packages.
insert into tablename a column1, column2 select column1, column2 from tablename b i am getting abend -104..can any one help?
List some fields from sqlca?
Can you access the DB2 Directory table using SQL?
suppose in my table 10 rows are there , i want to update odd rows salary as 90000 ? how u do it ? any one help me ? what do we use here cursor-fetch or normal sql ?
Explain an outer join?
COBOL 
