0 - 5 of 5 tags for ri

Hi Forum,

 

I have a table created as SET table using IDENTITY column as UPI and it has data in it.

Now, the user wants us to change it to MULTISET, but, as the PI is on Identity column how can I do this?

 One of our data modelers came to me with the following scenario.  He is creating two tables and defining a foreign key on one that references the other.
CREATE  TABLE EDWSPACE.AMK_ACCT_ANC
(              ACCT_ID              INTEGER NOT NULL ,
                LOAD_TS              TIMESTAMP NOT NULL
)

Hi Everyone,
 
I am trying to write a SOFT RI between a bi temporal parent table and non Tempral child table but it is thoring me an error "Invalid referential integrity definition"
 

ALTER TABLE EMAIL

ADD CONSTRAINT ALE_SDRI_2  

 NONSEQUENCED VALIDTIME  

 FOREIGN KEY (LOCATION_ID) 

I've found an appendix at the end of TD 13.10's "Temporal Table Support" reference, which contains some SQL code about how can you validating temporal referential integrity shown below. It works great until I want to embed it to a trigger's ...WHEN ( EXISTS (<here>))... section.

I've read the most relevant references from the TD 13.10 documents, but as I see, only soft RI-s are available with temporality - so you must do it yourself...

Which is the most acceptable (and also the simplest) solution maintaining RI's between temporal tables? TRIGGERs?