Insert ROW-TYPE variable into table without explicitly typing all column names

[aristos_kapnias]

Hello all,
As far as I understand triggers hold the record about to be inserted/updated as a row variable which I am able to use by referencing its parts. Example:

CREATE TRIGGER TEST_TRIGGER_VAR_UPDATE
AFTER UPDATE ON TARGET
REFERENCING NEW ROW mynewrow, OLD ROW myoldrow
FOR EACH ROW
BEGIN
INSERT INTO SAMPLE_new VALUES(:mynewrow.a, :mynewrow.b);
END;

This is unacceptable for me as I want to create triggers on 50+ tables and I cannot explicitly state all of the collections elements for all these tables.
I need sth like INSERT INTO SAMPLE_new VALUES(:mynewrow.*);
or
INSERT INTO SAMPLE_new SELECT * FROM (:mynewrow);

Thanks

[HermannGahm]

Hi, have you checked if the statement wise trigger fits your needs? (see https://help.sap.com/docs/HANA_SERVICE_CF/7c78579ce9b14a669c1f3295b0d8ca16/20d5a65575191014946db96aa...)

[aristos_kapnias]

@HermannGahm feature not supported: Cannot create statement trigger on column table