Re: Referential Constraint

[Doug Palme <DPalme@xxxxxxxxxxx>]

   Can I have both a foreign key and a check constraint within the same DDL
   File?

   It seems to be puking out on the check constraint....

   From:     rob@xxxxxxxxx                                                    
   To:       Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>  
   Date:     12/12/2008 12:14 PM                                              
   Subject:  Re: Referential Constraint                                       

     ----------------------------------------------------------------------

   > CREATE TABLE ROB/DMASTER
    (MYKEY INT NOT NULL,
    MASTERDATA CHAR,
    PRIMARY KEY (MYKEY))

   > CREATE TABLE ROB/DCHILD
    (DCHILDKY CHAR (1 ) NOT NULL,
    MYKEY INT NOT NULL WITH DEFAULT,
    SOMEDATA CHAR (30 ) NOT NULL WITH DEFAULT,
    PRIMARY KEY (DCHILDKY),
    FOREIGN KEY (MYKEY) REFERENCES ROB/DMASTER (MYKEY)
      ON DELETE NO ACTION ON UPDATE NO ACTION)

   Rob Berendt
   --
   Group Dekko Services, LLC
   Dept 01.073
   Dock 108
   6928N 400E
   Kendallville, IN 46755
   http://www.dekko.com

   From:
   Doug Palme <DPalme@xxxxxxxxxxx>
   To:
   Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
   Date:
   12/12/2008 11:52 AM
   Subject:
   Referential Constraint
   Sent by:
   midrange-l-bounces@xxxxxxxxxxxx

     I have  been going through the SQL manual most of the morning trying to
     figure out how to add a referential constraint on a table that is based
     upon values in another table.....

     Does anyone have a sample that I could take a look at? The SQL manual
     leaves a tad to be desired on that.
     This transmission may contain information that is privileged,
   confidential
     and/or exempt from disclosure under applicable law. If you are not the
     intended recipient, you are hereby notified that any disclosure,
   copying,
     distribution, or use of the information contained herein (including any
     reliance thereon) is STRICTLY PROHIBITED. If you received this
     transmission in error, please immediately contact the sender and
   destroy
     the material in its entirety, whether in electronic or hard copy
   format.
     Thank you.
   --
   This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
   list
   To post a message email: MIDRANGE-L@xxxxxxxxxxxx
   To subscribe, unsubscribe, or change list options,
   visit: http://lists.midrange.com/mailman/listinfo/midrange-l
   or email: MIDRANGE-L-request@xxxxxxxxxxxx
   Before posting, please take a moment to review the archives
   at http://archive.midrange.com/midrange-l.

   --
   This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
   list
   To post a message email: MIDRANGE-L@xxxxxxxxxxxx
   To subscribe, unsubscribe, or change list options,
   visit: http://lists.midrange.com/mailman/listinfo/midrange-l
   or email: MIDRANGE-L-request@xxxxxxxxxxxx
   Before posting, please take a moment to review the archives
   at http://archive.midrange.com/midrange-l.

   This transmission may contain information that is privileged, confidential
   and/or exempt from disclosure under applicable law. If you are not the
   intended recipient, you are hereby notified that any disclosure, copying,
   distribution, or use of the information contained herein (including any
   reliance thereon) is STRICTLY PROHIBITED. If you received this
   transmission in error, please immediately contact the sender and destroy
   the material in its entirety, whether in electronic or hard copy format.
   Thank you.