Well, the regular way how to do that is : upsert into TABLE (pk1, pk2, pk3, column_to_change) select pk1, pk2, pk3, 'new_value' from TABLE where ...
So you have to provide ALL columns for PK. Thanks, Sergey On Mon, Nov 6, 2017 at 8:04 AM, Adi Kadimetla <[email protected]> wrote: > Hi Team, > > I need help to update cache_size in SYSTEM."SEQUENCE" for a > SEQUENCE_NAME. I tried below upsert command but there is no upsert syntax > with where clause. > > > upsert into SYSTEM."SEQUENCE"(CACHE_SIZE) VALUES(0) where > SEQUENCE_NAME='SUBSCRIPTION_SEQUENCE' > > Thanks > >
