SAP Knowledge Base Article - Preview

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

Symptom

  • 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).

Read more...

Environment

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

Product

SAP PowerDesigner 16.5 ; SAP PowerDesigner 16.6

Keywords

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

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.