Is it possible to open two cursors with WITH HOLD

rkr · New User Joined: 19 Apr 2005 Posts: 12

Hi
can anybody tell me that, is it possible to open two cursors in same program with WITH HOLD option.
actually i faced this question in an interview in Accenture.
So plz clear me asap.

Pushpak · New User Joined: 06 May 2005 Posts: 18

Hi,

I have tested it. It works. Two cursors with " WITH HOLD" option for 2 diff tables in same program. It is working fine.

Pushpak.

rkr · New User Joined: 19 Apr 2005 Posts: 12

Hi
thanx for clearing my doubt.
But can we open two cursors on same table in the same program.
thanx in advance.

Pushpak · New User Joined: 06 May 2005 Posts: 18

Hi,

DB2-SQL provided very good features, like JOIN,UNION,Subqueries, Corelated subqueries & so on, for developers to combine two diff/same tables & get the results.

You don't need to try two cursors on same table in same program, instead you can use any of the above features to satisfy your requirement.

Pushpak.