CREATE MULTISET VOLATILE TABLE updatetable(
id INTEGER,
name VARCHAR(100),
indicator_flag CHAR(1)
)
PRIMARY INDEX(id)
ON COMMIT PRESERVE ROWS;
Q1JFQVRFIE1VTFRJU0VUIFZPTEFUSUxFIFRBQkxFIHVwZGF0ZXRhYmxlKAogICAgaWQgSU5URUdFUiwKICAgIG5hbWUgVkFSQ0hBUigxMDApLAogICAgaW5kaWNhdG9yX2ZsYWcgQ0hBUigxKQopClBSSU1BUlkgSU5ERVgoaWQpCk9OIENPTU1JVCBQUkVTRVJWRSBST1dTOw==