I´m having some problem retrieving identity value from my newly
inserted row into a view.

I have two tables T1 and T2 which I define as following

CREATE TABLE T1
(
 id BIGINT GENERATED ALWAYS AS IDENTITY
 (
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    NO CYCLE
    NO ORDER
    CACHE 20
 ),
 t1name VARCHAR(10),
 CONSTRAINT c_k2_column_reference_id_pk PRIMARY KEY(id)
);

CREATE TABLE T2
(
 id BIGINT GENERATED ALWAYS AS IDENTITY
 (
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    NO CYCLE
    NO ORDER
    CACHE 20
 ),
 t2name VARCHAR(10),
 t1id BIGINT,
 CONSTRAINT c_k2_column_reference_id_pk PRIMARY KEY(id)
);
ALTER TABLE T2
ADD CONSTRAINT t1id_fk
FOREIGN KEY( id )
REFERENCES t1 (id)
ON DELETE NO ACTION
ON UPDATE NO ACTION ;

I created view V 1to combine those two table as following
CREATE VIEW V1 AS
 SELECT  t1.id,
         t1.t1name,
         t2.id,
         t2.t2name
 FROM    t1

 JOIN t2
 ON   t2.id = t1.id;

At last I created insert trigger T1 to be able to insert into my view
CREATE TRIGGER t1
INSTEAD OF INSERT ON v1
REFERENCING NEW AS v1new
FOR EACH ROW
MODE DB2SQL
BEGIN ATOMIC
   INSERT INTO t1(t1name)
   VALUES (v1new.t1name);

   INSERT INTO t1( t2name, t1id)
   VALUES (v1new.t2name, IDENTITY_VAL_LOCAL()) ;

END;

Now I can insert into my view by doing

INSERT INTO v1 (t1name, t2name) value('test1', 'test2');

but when I call IDENTITY_VALUE_LOCAL() i get null value but I´m
interested in to retrieve id value of table T2 which I´m interested
in.

Can anyone help me on how I can retriveve the identity value of newly
created row by the trigger outside the trigger scope?

regards,
Gunnar