update a value in table.

[Former Member]

Hi Gurus,

I needed to write a small program to update the value of TVARV-LOW to F, programatically. for the already existing entries of TVARV where type = P, numb = 0001, sign = I, and option = EQ.

Can you please help..

Rgds

[Former Member]

Hi,

You can do as below:

UPDATE TVARV SET   low = 'F' 
               WHERE type  = 'P'   AND 
                     numb = '0001' AND 
                     sign = 'I' and 
                   option = 'EQ'.

Thanks,

Sriram Ponna.

[Former Member]

Thanks a lot... it helped.