saravana400
New User
Joined: 15 Feb 2010 Posts: 1 Location: Chennai
|
|
|
|
Hi,
Is it possible to use FOR UPDATE option and ORDER BY in the same declare statment. I want to update all the rows of the table. As my table might not be in sorted order.
EXEC SQL
DECLARE PRC-CRS CURSOR WITH HOLD FOR
SELECT DISTINCT T1.ITM_NBR
FROM A.ET_STK_LCT_PRC T5710
WHERE A.LC_NBR = :T3-LC-NBR
FOR UPDATE
END-EXEC.
Is FOR UPDATE is not necessary, will the declare cursor default to UPDATE option?
Thanks |
|