There is an undocumented feature, which is suppose
to be documented (have filed a documentation defect) that will
handle this situation. You can substitute a Macro for the
column name which will expand into the columname when you
generate DDL or forward engineer to the database. For columns
the Macro is @columname. For example
If I define the Domain Check Constraint to be:
@columname <> 100
Then create a table with two columns using this domain,
code generated looks like this:
CREATE TABLE T_0 (
COL_0 SMALLINT NOT NULL,
COL_1 SMALLINT NOT NULL
);
ALTER TABLE T_0 ADD CHECK (COL_0 <> 100);
ALTER TABLE T_0 ADD CHECK (COL_1 <> 100);
Patrick Kennedy
Rational Support
-----Original Message-----
From: Jos� Luis Santiago Fern�ndez [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 29, 2002 5:01 AM
To: [EMAIL PROTECTED]
Subject: (ROSE) Data Modeler Check Constraints
When I define a domain specification I can create a check constraint. In
this constraint I must define the check body.
My problem is that when I use the domain in a table definition, the
constraint use the domain name in the check, not the column name. How can I
solve this?
Best regards
Jos� Luis Santiago
************************************************************************
* Rose Forum is a public venue for ideas and discussions.
* For technical support, visit http://www.rational.com/support
*
* Post or Reply to: [EMAIL PROTECTED]
* Subscription Requests: [EMAIL PROTECTED]
* Archive of messages:
* http://www.rational.com/support/usergroups/rose/rose_forum.jsp
* 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
*
* Post or Reply to: [EMAIL PROTECTED]
* Subscription Requests: [EMAIL PROTECTED]
* Archive of messages:
* http://www.rational.com/support/usergroups/rose/rose_forum.jsp
* Other Requests: [EMAIL PROTECTED]
*
* To unsubscribe from the list, please send email
* To: [EMAIL PROTECTED]
* Subject: <BLANK>
* Body: unsubscribe rose_forum
*************************************************************************
