Toad World® Forums

Some problems with trigger property


#1

Hi,

Class: PERTriggerEntityDB9.

According to documentation:

  1. Event has DataType = String. To setup correct value I used:
    Trigger.Event = “D”; //Trigger Event = INSERT, UPDATE, DELETE
    Problem: Can’t setup value = “DELETE”
    // only FIRST letter works
  2. Fire has DataType = String. To setup correct value I used:
    Trigger.Fire = “A”; //Trigger Time = BEFORE, AFTER
    Problem: Can’t setup value = “AFTER”
    // only FIRST letter works
  3. Schema has DataType = PERSchemaDB

Trigger.Schema = “XXX”; // value not changed
Trigger.Schema.Name = “XXX”; // value not changed
Problem: How to setup value ?

Best regards,

Adam


#2
  1. Property Schema is of type Dispatch. So, while defining the property, you have to refer to existing object in list Schemas.
    Please find attached a script that adds schema “MySchema” to all entities in the model. If the “MySchema” does not exist in the model, the script will create it.

Regards,

Vladka + Mario

Hello Adam,

Yes, the script we sent you last time was valid for MySQL, including the notes in the script.
See the thread at:
http://modeling.inside.quest.com/thread.jspa?messageID=26282

        • Yes, in DB2 db you have to set up different values than e.g. in MySQL, just as you write.
          AssignMySchema.zip (507 Bytes)

#3

Hello Vladka + Mario,

Thank You for Your answer.

It works.

Best regards,

Adam