This section provides examples that show how the atomic upsert form of UPDATE works, including error cases. All examples use the same table called sales, which is defined as:
CREATE TABLE sales, FALLBACK item_nbr INTEGER NOT NULL, sale_date DATE FORMAT 'MM/DD/YYYY' NOT NULL, item_count INTEGER) PRIMARY INDEX (item_nbr);
Assume that the table has been populated with the following data.
INSERT INTO sales (10, '05/30/2000', 1);