Switch to: V9V8V7V6V5

KEYVALUE UPSERT

Syntax

KEYVALUE keyvalue_name [OF TABLE table_name | OF LINK link_name]
    UPSERT ( vext_keyvalue_list )
     [FOR RECORD { UINT | vext_link_list_of_records } ]
vext_keyvalue_list
    :    vext_keyvalue, ...
 
vext_keyvalue
    :    vext_key COLON vext_value
 
vext_key_list
    :    vext_key, ...
 
vext_key
    :    character_string_literal
 
vext_value
    :    character_string_literal
    |    variable_name
    |    dynamic_parameter_specification
    |    TRUE
    |    FALSE
vext_link_list_of_records
    :   ( vext_link_value, ... )
 
vext_link_value
    :   UINT | dynamic_parameter_specification

Description

This command do UPDATE or INSERT.

IF the given KEY exists in KeyValue store, then it UPDATEs it by a new VALUE, otherwise, it INSERTs pair KEY:VALUE.

Examples

KEYVALUE kvProperties UPSERT
(
    '545.name' : 'Bob',
    '545.age'  : 29
);

See Also