tecnokrat Warnings : 1 Active User
Joined: 22 May 2009 Posts: 160 Location: Bangalore
|
|
|
|
Hi,
i have a requirement to update a particular valuein a tbale.
First i have retrieved the values from the table
Code: |
SELECT A_1,B_1,B_2,B_3
INTO
:A-1,:B-1 :NULL,:B-2 :NULL1,:B-3 :NULL2
FROM TABLE A
WHERE A= :A
B = :B
|
where the b_1 b_2 b_3 are null defined
base on the condition
Code: |
IF NULL <0 and
NULL1 < 0 and
NULL2 < 0
MOVE CURRENT DATE TO hold-var
ELSE
CONTINUE
END-IF.
|
earlier the value picked up from the A_1 has default date 0001-01-01
now i have to update the value
Code: |
UPDATE TABLE A
SET A_1 = :HOLD-VAR
WHERE B_1 = :B-1
|
NOW im evaluating the hosst variable
A-1
it still has the value 0001-01-01 while i have updated just before this
can u help me out like the host variable does hold the value of previous fetch or the updated value because here after updation of A_1 im not fetching the value from the table. |
|