Can I update other columns during processing

Anand78 · New User Joined: 06 Mar 2006 Posts: 50 Location: PUNE

Hi all,
I have five columns C1.........C5,

While declaring cursor , If I declare cursor with update option only for column C1, In this case can I update other columns during processing?

Regards
ANAND

unni_nss · New User Joined: 20 Sep 2005 Posts: 19

hi,
its not possible.you may be coding like update option as,

DECLARE CURSOR cursr_name ON table_name UPDATE column_name SET column_name = value etc.

So in this case you can update the column name what we mentioned in the cursor!

sri.mainframes · New User Joined: 16 Feb 2006 Posts: 29 Location: MUMBAI

Hi Anand,

You want to update the table or cursor?
if u want to update the table, it is not possible while processing.
if u want to declare one more cursor it's not allowing u becoz the table is in use

correct me if i am wrong

thanks
sri.prince