phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Adi Kadimetla <kadime...@gmail.com>
Subject how to update cache_size in SYSTEM."SEQUENCE"
Date Mon, 06 Nov 2017 16:04:19 GMT
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

Mime
View raw message