Update from ADO

how to update a flag in db2 side written as this1)

conn.Execute “insert into QGPL.SALES SET (FLAG) values(‘1’)”

'insert into QGPL.Sales SET Flag values ‘1’

'insert into ‘tablename’ SET ‘fieldname1’, ‘fieldname2’ values ‘value1’,‘value2’

rs.Update

none is working pls help