I’m trying to create a db 2 trigger and I need to explicitly set the terminator trigger in my sql statement. The following is my changeset. Can someone please assist? If this is a bug, can someone give me some help on where to fix it? Thanks
–#SET TERMINATOR /
create trigger test_insert_trg
after insert on test
referencing new as newdata
for each row
mode DB2SQL
begin atomic
insert into HIST
(
ID,
TEST_NR,
TEST_NM,
)
values(
newdata.ID,
newdata.TEST_NR,
newdata.TEST_NM,
);
end
/
-
Learn
-
Resources
-
Free Tools
OSS Risk Scanner Database DevOps Risk AssessmentCheat Sheets
Snowflake + Liquibase Databricks + Liquibase -
eBooks
6 Liquibase Community Risks & How to Avoid Guide: SOC 2 Compliance at the Database Layer Guide: Quantify the Value of Liquibase Secure -
Comparison Guides
Liquibase vs. Flyway Liquibase vs. Bytebase Liquibase Community vs Liquibase Secure
-
- Quickstart
- Get Started
- Documentation
- University
-
Resources
- Connect
- Contribute
- Join
- Blog