CREATE TABLE TEST.TABLE1  (
		  F1 INTEGER NOT NULL , 
		  F2 INTEGER NOT NULL , 
		  F_XML XML);

CREATE VIEW TEST.TABLE1_VIEW (F1 ,F2,ID) AS
SELECT 
	F1,
	F2,	
	XMLCAST(XMLQUERY('$F_XML/ROOT/C[@T="3"]/@ID') AS INTEGER) AS ID 
	FROM TEST.TABLE1

CREATE TRIGGER TEST.TABLE1_VIEW_INSERT INSTEAD OF INSERT ON TEST.TABLE1_VIEW 
REFERENCING NEW AS N 
FOR EACH ROW MODE DB2SQL 
BEGIN ATOMIC
MERGE INTO TEST.TABLE1 C
USING (
		SELECT 
			N.F1,
			N.F2,
			N.ID
		FROM 
			SYSIBM.SYSDUMMY1
		) T 
		ON C.F1=T.F1
WHEN 
	NOT MATCHED THEN
		INSERT(
			F1,
			F2,
			F_XML
			) 
		VALUES(
			T.F1,
			T.F2,
			XMLDOCUMENT(XMLQUERY('<ROOT><C T="1" ID="1"/><C T="3" ID="{$c}"/></ROOT>' passing T.ID as "c"))
			)
WHEN MATCHED THEN
UPDATE SET
	F2=T.F2,
	F_XML=XMLQUERY('copy $new :=$f_xml modify do replace value of $new/ROOT/C[@T="3"]/@ID with $c return $new' passing T.ID as "c",CASE WHEN F_XML IS NOT NULL THEN F_XML ELSE XMLPARSE(DOCUMENT '<ROOT/>' STRIP WHITESPACE); END as "f_xml");
END

UPDATE SET
	F2=T.F2,
	F_XML=XMLQUERY('copy $new :=$f_xml modify do replace value of $new/ROOT/C[@T="3"]/@ID with $c return $new' passing T.ID as "c",F_XML as "f_xml");

insert into TEST.TABLE1_VIEW VALUES(1,1,2);