Siebel System Admin, Install and Upgrade (MOSC)

MOSC Banner

Create Trigger being generated in schema.sql for DB2 for z/OS upgrade

We are running the synchronize step prior to creating the staging schema. We are still generating a number of create trigger sql in the schema.sql inspite of having applied this to the database.

e.g. DROP TRIGGER SIEBEL.PTH0364

  /
  CREATE TRIGGER SIEBEL.PTH0364 NO CASCADE BEFORE INSERT ON
  SIEBELDA.S_ACCNT_POSTN REFERENCING NEW AS N FOR EACH ROW MODE
  DB2SQL WHEN (N.OU_EXT_ID IS NOT NULL) BEGIN ATOMIC SET
  N.PARTITION_COLUMN = RIGHT(N.OU_EXT_ID, 2); END

The bookshelf states no sql should be generated, i.e. physical and logical schema should be the same.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center