RE: Foreign key constraint problem

["Jeff Crosby" <jlcrosby@xxxxxxxxxxxxxxxx>]

Did that.  Then I get this in the joblog:

Message ID . . :   CPD32B0       Severity . . . :   20
Message type . :   Diagnostic
Date sent  . . :   05/31/07      Time sent  . . :   16:03:28

Message . . . . :   Constraint is not valid.
Cause . . . . . :   Constraint CATALOGFK cannot be added for file DMITMMST
in library JEFF for TYPE value *REFCST. For a referential constraint (TYPE
*REFCST), the parent file DMCATMST in library JEFF has a delete rule of
*RESTRICT and update rule of *RESTRICT. The constraint was not added because
of errors. The reason code is 12. The reason codes and their meanings are as
follows:                                                                    

<snip>                            

12 - The parent key does not exist.

<snip>

Recovery  . . . :   Do one of the following based on the reason code shown,
and then try the request again.                                          

<snip>

12 - Add primary key or unique constraint (ADDPFCST) to parent file.


The parent file's unique key is field CTCODE, which is the field I'm
referencing.