Hi all,

I'm using Data Modeler in version 2.0. 

I've got a data model, that uses domains, implemented as user defined data types on MS 
SQL Server.

There are two problems:
1. The ddl script created doesn't reflect the NULL/NOT NULL value I choose for the 
domains: I've got 55 domains, all marked NULL within the data modeler.
Within my ddl-script 26 of them are marked as NOT NULL, the rest as NULL.

2. When I use my user defined data types within CREATE-TABLE-Statements, there's no 
NULL/NOT NULL option marked any more. 
MSSQL Server BOL: 
"Note The null_type parameter only defines the default nullability for this data type. 
If nullability is explicitly defined when the user-defined data type is used during 
table creation, it takes precedence over the defined nullability."

Is there any solution to it?
        Frank


--
Frank Rogler            mailto:[EMAIL PROTECTED]
sd&m AG         http://www.sdm.de
software design & management
Thomas-Dehler-Str. 27 ,         D-81737 Muenchen, Germany
Tel +49 89 63812-255  Fax -150


************************************************************************
* 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
*************************************************************************

Reply via email to