1. What is referential integrity in DB2/400?
Method to ensure that a value in a "dependent field" in one file exists in the independent field of another file. For example: A method to ensure that the customer number in the order file exists in the customer file. This is often done in programs but it can also be set as database rules using the command

Add Physical File Constraint (ADDPFCST)

Here is web site
http://www.mcpressonline.com/database/db2/db2/400-referential-integrity.html

What is field reference file in DB2/400?
The field reference file is used as a data dictonary of sorts. It contains field/column definitions (field names, sizes and types, titles and column headings.

So our Field Reference file might contain the definition for customer Number
FDRCUST# 6S 0 TITLE('Customer Number')
COLHDG('Customer' 'Number')

Then our OrderHeader file could contain the field definition
ORDCUST# R REFFLD(FDRCUST#/FDRFILE)

And in our Customer File
CUCUST# R REFFLD(FDRCUST#/FDRFILE)

We know the two fields will have the same structure because they inhereted it from the same parent.

Phil

Please complete the following information:

REGISTER / LOG-IN TO DISCUSS

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

Submit your e-mail address below to continue

E-mail: 

E-mail: 

Handle:   

Password: 

Forgot Password?

Create Handle: 

Your handle identifies you in ITKnowledgeExchange. Max 30 char.

Create Password: 

Confirm Password: 

Yes, I agree to the IT Knowledge Exchange  Terms and Conditions.

hidden modal window