![]() |
Hi All,
I have to implement a soft ri in one of my project.
Following are the tables in PER_DATA:
person_mst with columns p_num bigint p_dt date p_status char(1)
composite key is defined on columns p_num and p_dt person_mst was created by user xyz.
08 Jun 2013
| 4 comments
,
|
![]() |
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.
28 Oct 2011
| 1 comment
,
|
![]() |
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?
07 Oct 2011
| 3 comments
,
|