Re: PeopleSoft and Referential Integrity

On Fri, 08 Aug 1997 01:58:42 GMT, twincrk_at_ral.mindspring.com (S. Fleming) wrote:

>To be perfectly honest, I am a PeopleSoft developer with somewhat
>limited Oracle skills so I really don't know what you are asking.
>However, when you generate a SQL script from the Data Designer you get
>something like the one shown below. The only parameters that
>PeopleSoft lets you change in the Data Designer are the init and next
>sizes and the tablespace name. Those changes are saved and
>automatically placed in the script when the script is generated again.

< script snipt >

The answer is: PeopleSoft's generated DDL doesn't use declarative RI (the script used CREATE UNIQUE INDEX rather than a CONSTRAINT clause) and you can't change it to make it do so.

Phil

--
Phil Edwards                    phil_at_news400.com
Editor, NEWS/400.uk             +44 (0)161 929 0777