Designer2000 - Sub-type implementation
Date: 1996/05/30
Message-ID: <31ADD5CB.3358_at_ea.com>#1/1
Hello,
I am experimenting with DDL generation from ERDs using Designer2000. I am trying to have the DDL Generator
generate a create table statement that includes a 'discriminator column' for use in determining sub-types. My
scenario is very simple:
I have one entity (called TABLE1) with two sub-types (TYPE1 and TYPE2). I have an ERD reflecting this. In
the 'table mapping' part of the DB DEsign Wizard, I have mapped as follows:
(And of course, I include all these in my 'run set'.) According to Oracle docs, this mapping should result in
TABLE1 having a discriminator column called (something like) 'TYPE'. Instead, it creates three 'create table'
TABLE1 No Mapping
--TYPE1 Include
--TYPE2 Include
I have checked the help for "Implementing a Single Table Approach for Mapping Sub-Types" which says to do what I have done above. Oracle support hasn't helped as of yet.
Can anyone help me? Thanks in advance!
PLEASE EMAIL: afischer_at_ea.com
Thanks! Received on Thu May 30 1996 - 00:00:00 CEST