IF NOT EXISTS (SELECT 1 FROM tab WHERE colcode = 'xxx') THEN
INSERT INTO tab (colcode, colname, colversion) VALUES ('tr1', 'MyTree',
'version: 1')
ELSE
UPDATE tab SET colname = 'MyTree', colversion = 'version: 1' WHERE colcode =
'tr1'
END IF