DB2 Interview question at HSBC

prasadk432 · New User Joined: 22 Dec 2007 Posts: 9 Location: Gurgaon

In cursors after fetch statement in procedure division if you code count() whether the data updated in latest query can be accessible or not.

dick scherrer · Posted: Wed Feb 06, 2008 9:56 pm

Hello,

Please re-word your question.

The posted question is not clear (at least not to me

).

Please keep in mind that while your question is completely clear to you, it may not be to others who read the question.

prasadk432 · New User Joined: 22 Dec 2007 Posts: 9 Location: Gurgaon

Yes Dick,

I was asked after fetch statement in cursor if you code count statement whether you can access last updated data or not.Please give the solution

ashwinreddy · Posted: Tue Feb 12, 2008 12:59 pm

Hi,

You are confused with the Questions.

How can a Fetch stmt will update a table.

or You mean you have declared a cursor with delete and trying to find count the number of rows after delete.

Cheers
Ashwin

prasadk432 · New User Joined: 22 Dec 2007 Posts: 9 Location: Gurgaon

Not like that update stmt would be issued before fetch and that updated data can be accessed after some fetch and count stmt or not.

Now I think it is clear.

ashwinreddy · Posted: Tue Feb 12, 2008 3:58 pm

Hi,

Either you update the Table before fetch or after, it doesn't impact the Count in Table.

As far as i know the count will only differ from the original value when you either delete or insert a row.

Hope this Helps!

Cheers
Ashwin