Re: Help NewBie Question on record locking
> I am new to informix and would like to ask how I could select a row for
> updating. I know in Oracle, you could declar a SQL statement that is
> SELECT FOR UPDATE, is there a equivanlent of this in informix ??
>
> Basically, how do I lock a row for updating ??
DECLARE lock_cursor CURSOR FOR
SELECT *
FROM tableFOR UPDATE
FOREACH lock_cursor INTO gr_table.*
-- do your stuff here
END FOREACH
--
Cheers,
Billy
-----------------------------------------------------------
e-ddress: billy.wheeler@pixie.co.za
Work: +27 11 803 2151
Fax: +27 11 803 2189
Cell: +27 83 250 2324
GCM/CS d++(--) h--- s+:++ !g p?+ au++ a? w+ v++/* C+++ 3 k-
UCLAVH++++ p+++ L++ E-- N++ W--- M" V-- -po+ y+ t+ !5 j++
R+ G? tv+ b+++ D+ B-- e+ u** h----(++) f+ r+++ !n z++++/**
-----------------------------------------------------------