2487834 - DB2 requires a different statement terminator for CREATE TRIGGER - SAP PD

• Defining a trigger, the semi-colon is used to delimit SQL statements between the BEGIN ATOMIC and END keywords.
• IBM DB2 requires a different terminator for the overall CREATE TRIGGER statement.
• SAP PowerDesigner uses the same statement terminator:

CREATE TRIGGER trigger-name
AFTER UPDATE OF column-2 ON table-1
REFERENCING NEW AS table-2
FOR EACH ROW
BEGIN ATOMIC
INSERT INTO table-3
VALUES (table-2.col-1, table-2.col-2, CURRENT TIMESTAMP);
END;

• Changing the value Script\Sql\Syntax\BlockTerminator in the DBMS resource file (XDB) applies to all SQL statements (DROP, CREATE, ALTER).

• SAP PowerDesigner (PD) 16.5
• SAP PowerDesigner (PD) 16.6
• IBM DB2

db2mvs, BlockTerminator, 809133, CR809133, CR#809133 , KBA , BC-SYB-PD , PowerDesigner , Product Enhancement