CREATE MULTISET VOLATILE TABLE updatetable(
    id INTEGER,
    name VARCHAR(100),
    indicator_flag CHAR(1)
)
PRIMARY INDEX(id)
ON COMMIT PRESERVE ROWS;
 
CREATE  MULTISET VOLATILE TABLE othertable(
    id INTEGER,
    name VARCHAR(100),
    indicator_flag CHAR(1)
)
PRIMARY INDEX(id)
ON COMMIT PRESERVE ROWS;
 
INSERT INTO updatetable VALUES(1,'Teradata',null);
INSERT INTO updatetable VALUES(2,'Database',null);
INSERT INTO updatetable VALUES(3,'Oracle',null);
INSERT INTO updatetable VALUES(4,'Vertica',null);
 
INSERT INTO othertable VALUES(1,'Teradata','Y');
INSERT INTO othertable VALUES(2,'Database','N');
INSERT INTO othertable VALUES(5,'DB2','Y');
INSERT INTO othertable VALUES(6,'MYSQL','Y');
 
UPDATE tempAggr
FROM updatetable as tempAggr,
     othertable as tempTableAlias
SET indicator_flag = tempTableAlias.indicator_flag
WHERE tempAggr.id = tempTableAlias.id;

Q1JFQVRFIE1VTFRJU0VUIFZPTEFUSUxFIFRBQkxFIHVwZGF0ZXRhYmxlKAogICAgaWQgSU5URUdFUiwKICAgIG5hbWUgVkFSQ0hBUigxMDApLAogICAgaW5kaWNhdG9yX2ZsYWcgQ0hBUigxKQopClBSSU1BUlkgSU5ERVgoaWQpCk9OIENPTU1JVCBQUkVTRVJWRSBST1dTOwoKQ1JFQVRFICBNVUxUSVNFVCBWT0xBVElMRSBUQUJMRSBvdGhlcnRhYmxlKAogICAgaWQgSU5URUdFUiwKICAgIG5hbWUgVkFSQ0hBUigxMDApLAogICAgaW5kaWNhdG9yX2ZsYWcgQ0hBUigxKQopClBSSU1BUlkgSU5ERVgoaWQpCk9OIENPTU1JVCBQUkVTRVJWRSBST1dTOwoKSU5TRVJUIElOVE8gdXBkYXRldGFibGUgVkFMVUVTKDEsJ1RlcmFkYXRhJyxudWxsKTsKSU5TRVJUIElOVE8gdXBkYXRldGFibGUgVkFMVUVTKDIsJ0RhdGFiYXNlJyxudWxsKTsKSU5TRVJUIElOVE8gdXBkYXRldGFibGUgVkFMVUVTKDMsJ09yYWNsZScsbnVsbCk7CklOU0VSVCBJTlRPIHVwZGF0ZXRhYmxlIFZBTFVFUyg0LCdWZXJ0aWNhJyxudWxsKTsKCklOU0VSVCBJTlRPIG90aGVydGFibGUgVkFMVUVTKDEsJ1RlcmFkYXRhJywnWScpOwpJTlNFUlQgSU5UTyBvdGhlcnRhYmxlIFZBTFVFUygyLCdEYXRhYmFzZScsJ04nKTsKSU5TRVJUIElOVE8gb3RoZXJ0YWJsZSBWQUxVRVMoNSwnREIyJywnWScpOwpJTlNFUlQgSU5UTyBvdGhlcnRhYmxlIFZBTFVFUyg2LCdNWVNRTCcsJ1knKTsKClVQREFURSB0ZW1wQWdncgpGUk9NIHVwZGF0ZXRhYmxlIGFzIHRlbXBBZ2dyLAogICAgIG90aGVydGFibGUgYXMgdGVtcFRhYmxlQWxpYXMKU0VUIGluZGljYXRvcl9mbGFnID0gdGVtcFRhYmxlQWxpYXMuaW5kaWNhdG9yX2ZsYWcKV0hFUkUgdGVtcEFnZ3IuaWQgPSB0ZW1wVGFibGVBbGlhcy5pZDs=