Upating Records

hi ColdfuisonDB2,

                      hope you need to remove existing data and inserts the new data there, for that you just use update statement..

example

          update your_tablename

          set

               column_1=newvalue1

              , column_2=newvalue2

              ......

              .....  

             ,columm_n=newvaluen

          where record_id=id

hope it helps...

thanks