# Adding a File Relationship for 2 ADABAS files, Constraint Attributes

**URL:** <https://techcommunity.softwareag.com/t/adding-a-file-relationship-for-2-adabas-files-constraint-attributes/201227>\
**Category:** Forum\
**Tags:** Adabas-Natural, Natural, Natural-Add-on-Products, Natural-Predict\
**Created:** [October 11, 2018, 7:55am UTC](https://techcommunity.softwareag.com/t/adding-a-file-relationship-for-2-adabas-files-constraint-attributes/201227 "2018-10-11T07:55:11Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Peggy](https://avatars.discourse-cdn.com/v4/letter/p/c37758/32.png) [@Peggy](https://techcommunity.softwareag.com/u/Peggy)\
**Post date:** [October 11, 2018, 7:55am UTC](https://techcommunity.softwareag.com/t/adding-a-file-relationship-for-2-adabas-files-constraint-attributes/201227/1 "2018-10-11T07:55:11Z")

</div>

My team is currently creating a new accounting system from scratch. This is on a mainframe, using Construct for Natural. By adding the file relationships to Predict, we can cut down on the amount of manual coding.

We have been through all documentation for Construct and Predict and can not seem to find any documentation for the File Relationships “Constraint Attributes”. We try PF1 and ‘?’ in the field and the help does not work. We did find out if you enter an invalid value, it will display a list of valid values, but no information about what each value does.  
\_ C Cascade  
\_ L Suffix as line-nr  
\_ N re-Number suffix  
\_ R Restrict  
\_ S Set NULL  
\_ ’ ’ (none)

Does anyone have documentation on What each of these values does in regard to the File Relationship. C, for Cascade is kind of obvious, but would still like to have Software AG’s actual documentation for these fields.

Seems like Software AG’s documentation for predict and construct is slowly going away.

---

<div class="post-metadata">

**Author:** ![Ralph\_Zbrog](https://sea1.discourse-cdn.com/techcommunity/user_avatar/techcommunity.softwareag.com/ralph_zbrog/32/78_2.png) [@Ralph\_Zbrog](https://techcommunity.softwareag.com/u/Ralph_Zbrog)\
**Post date:** [October 11, 2018, 7:40pm UTC](https://techcommunity.softwareag.com/t/adding-a-file-relationship-for-2-adabas-files-constraint-attributes/201227/2 "2018-10-11T19:40:40Z")

</div>

Predict documentation doesn’t have much detail on Constraint Attributes, but Construct documentation is specific in its requirements for them: [http://techcommunity.softwareag.com/ecosystem/documentation/natural/nbs822/objectmodels/overview-of-object-oriented-development.htm#define-object-relationships-in-predict](http://techcommunity.softwareag.com/ecosystem/documentation/natural/nbs822/objectmodels/overview-of-object-oriented-development.htm#define-object-relationships-in-predict)

---

<div class="post-metadata">

**Author:** ![Peggy](https://avatars.discourse-cdn.com/v4/letter/p/c37758/32.png) [@Peggy](https://techcommunity.softwareag.com/u/Peggy)\
**Post date:** [October 12, 2018, 7:59am UTC](https://techcommunity.softwareag.com/t/adding-a-file-relationship-for-2-adabas-files-constraint-attributes/201227/3 "2018-10-12T07:59:08Z")

</div>

Thanks for the link. I think I have read thru this once and did not get much meaning out of it. I will re-read. Just wish they had the kind of documentation they had 20 years ago for predict and construct.

Thanks for your help!

---

<div class="post-metadata">

**Author:** ![system](https://global.discourse-cdn.com/techcommunity/original/3X/c/d/cd19967bb605d28a72d77eb83a1cae22f3df2eb8.svg) [@system](https://techcommunity.softwareag.com/u/system)\
**Post date:** [April 2, 2021, 3:41pm UTC](https://techcommunity.softwareag.com/t/adding-a-file-relationship-for-2-adabas-files-constraint-attributes/201227/4 "2021-04-02T15:41:36Z")

</div>