Serge,
Sorry i wasn't as clear but this is a positioned update of each
record.
The temp table was used to change values of 3 columns but the values
of these columns for each record are different. So when i try to
update the master table from the temp table i thought i need to use a
cursor so that each row would be evaluated separately. Your thoughts
are greatly appreciated.
WofD
Serge Rielau <sr*****@ca.eye-bee-em.com> wrote in message news:<41********@news3.prserv.net>...
Thanos,
It should be FETCH c1 INTO <host variables>
Why do you use a cursor in the first place?
Try this:
UPDATE cfd_masterfile
set (record_source, insight_ind, exclude_ind) = (select
temp_both.record_src, temp_both.insight_ind, temp_both.exclude_ind
from session.temp_both temp_both
where cfd_masterfile.account_number =
session.temp_both.account_number)
where record_source <> 'PCG';
Cheers
Serge