Referential constraint

["Holden Tommy" <Tommy.Holden@xxxxxxxxxxxxxxxxx>]

Do a DSPFD on the file that should show the constraints & what file the
ref constraint is tied to... 


Thanks,
Tommy Holden


-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Banerjee, Amitava
Sent: Thursday, March 01, 2007 12:02 PM
To: rpg400-l@xxxxxxxxxxxx
Subject: RE: RPG400-L Digest, Vol 6, Issue 3

Hi,

I am working on a system that is new to me. Modified a RPG according to
client's requirement. 

When went for testing the RPG, I tried to delete a record from a file
(thought, after that would try to insert the same record, so that
'Deletion' and 'Insertion' will be tested) by interactive SQL, I got
'Referential Constraint' error.

Where or how can I find what is/are the other file(s) this file is
referencing to? Please help. 

Thank you,
Amitava
 
--------------------------------------------------------

This message (including any attachments) is only for the use of the
person(s) for whom it is intended. It may contain Mattel confidential,
proprietary and/or trade secret information. If you are not the intended
recipient, you should not copy, distribute or use this information for
any purpose, and you should delete this message and inform the sender
immediately.