Vince,
You need to set the Database to Oracle(you can use DB2, SQL Server too)
and then don't forget to link your schema to the database else the schema
will default to "ANSI SQL92" and you won't see the triggers.
here is a sample I generated
CREATE TABLE T_0 (
COL_0 SMALLINT NOT NULL,
CONSTRAINT PK_T_00 PRIMARY KEY (COL_0)
)
/
CREATE TRIGGER TRIG_T_00 BEFORE INSERT ON T_0
FOR EACH STATEMENT
COL_0 = 40
/
Siraj M. Shaik
Technical Support Engineer,Sr.,
Rose Support Group
Rational Software Corp.
the e-development company
Beaverton, OR 97006.
-----------------------------------------
-----Original Message-----
From: Gornik, Davor [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 22, 2001 1:38 PM
To: Bryan, Vincent (MIS, STP); '[EMAIL PROTECTED] '
Subject: RE: (ROSE) Using Rose Data Modeler to Forward Engineer Triggers
f or Oracle
Vincent,
This should work without any problems. I do it all of the time. What DB-type
do you use in the schema? Can you tell me more about your environment?
Btw. if you generate the DDL script, triggers can be found at the very end
of the script, not at the table definition, as they can relate to other
tables.
Davor
Davor Gornik
Marketing Engineer Rose Business Unit
Rational Software
Phone: +1-425-497-4091
Email: [EMAIL PROTECTED]
--------------------------------------------------------------------
Rational User Conference 2001
July 22 - 26, 2001 * Denver, CO, USA
http://www.rational.com/ruc
-----Original Message-----
From: Bryan, Vincent (MIS, STP) [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 22, 2001 11:21 AM
To: '[EMAIL PROTECTED] '
Subject: (ROSE) Using Rose Data Modeler to Forward Engineer Triggers for
Oracle
Have anyone been able to forward generate triggers from Rose 2001? I am
using Rose 2001 data modeller. I've created the logical data model, forward
generated the DDL and created a database schema.
Unfortunately, the forward engineering wizard does NOT actually generate
triggers even after I've said that it should. The attached graphic shows
the settings I'm using.
Thanks for any help.
Vincent.
-----Original Message-----
From: Ma Ding-CDM087
To: 'Aker, Eric'; 'Laureano Ruiz'; 'Rational Forum'
Sent: 3/22/2001 12:33 PM
Subject: RE: (ROSE) Compare two Rose models
Hi, all
I have another question. We are using ClearCase to track the versions of
the same model. Can we use the model integrator to compare two versions
of the same model?
Thanks
Ding
-----Original Message-----
From: Aker, Eric [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 21, 2001 1:53 PM
To: 'Laureano Ruiz'; 'Rational Forum'
Subject: RE: (ROSE) Compare two Rose models
Rose includes a tool called model integrator.
It compares up to 7 different models.
It is in the Rose pulldown menu "tools"
Eric
-----Original Message-----
From: Laureano Ruiz [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 21, 2001 11:45 AM
To: 'Rational Forum'
Subject: (ROSE) Compare two Rose models
Hi All,
Is there a script out there that would compare two Rose models? I would
only like to compare classes, everything else really doesn't matter
(i.e..
Diagrams, etc.). If there is none, how could this be accomplished in
the
fastest and easiest way? A file comparison, etc.?
Thanks,
J.Laureano Ruiz
[EMAIL PROTECTED]
(713) 210-8215
************************************************************************
* Rose Forum is a public venue for ideas and discussions.
* For technical support, visit http://www.rational.com/support
*
* Admin.Subscription Requests: [EMAIL PROTECTED]
* Archive of messages:
http://www.rational.com/products/rose/usergroups/rose_forum.jtmpl
* Other Requests: [EMAIL PROTECTED]
*
* To unsubscribe from the list, please send email
*
* To: [EMAIL PROTECTED]
* Subject:<BLANK>
* Body: unsubscribe rose_forum
*
************************************************************************
*
************************************************************************
* Rose Forum is a public venue for ideas and discussions.
* For technical support, visit http://www.rational.com/support
*
* Admin.Subscription Requests: [EMAIL PROTECTED]
* Archive of messages:
http://www.rational.com/products/rose/usergroups/rose_forum.jtmpl
* Other Requests: [EMAIL PROTECTED]
*
* To unsubscribe from the list, please send email
*
* To: [EMAIL PROTECTED]
* Subject:<BLANK>
* Body: unsubscribe rose_forum
*
************************************************************************
*
************************************************************************
* Rose Forum is a public venue for ideas and discussions.
* For technical support, visit http://www.rational.com/support
*
* Admin.Subscription Requests: [EMAIL PROTECTED]
* Archive of messages:
http://www.rational.com/products/rose/usergroups/rose_forum.jtmpl
* Other Requests: [EMAIL PROTECTED]
*
* To unsubscribe from the list, please send email
*
* To: [EMAIL PROTECTED]
* Subject:<BLANK>
* Body: unsubscribe rose_forum
*
************************************************************************
*
************************************************************************
* Rose Forum is a public venue for ideas and discussions.
* For technical support, visit http://www.rational.com/support
*
* Admin.Subscription Requests: [EMAIL PROTECTED]
* Archive of messages:
http://www.rational.com/products/rose/usergroups/rose_forum.jtmpl
* Other Requests: [EMAIL PROTECTED]
*
* To unsubscribe from the list, please send email
*
* To: [EMAIL PROTECTED]
* Subject:<BLANK>
* Body: unsubscribe rose_forum
*
*************************************************************************
************************************************************************
* Rose Forum is a public venue for ideas and discussions.
* For technical support, visit http://www.rational.com/support
*
* Admin.Subscription Requests: [EMAIL PROTECTED]
* Archive of messages:
http://www.rational.com/products/rose/usergroups/rose_forum.jtmpl
* Other Requests: [EMAIL PROTECTED]
*
* To unsubscribe from the list, please send email
*
* To: [EMAIL PROTECTED]
* Subject:<BLANK>
* Body: unsubscribe rose_forum
*
*************************************************************************
