PMS Information Systems
Welcome to PMS Information Systems - IBM i (AS/400) Forum !!!

Get Answers for all your queries on IBM i (AS/400).

Join the forum, it's quick and easy

PMS Information Systems
Welcome to PMS Information Systems - IBM i (AS/400) Forum !!!

Get Answers for all your queries on IBM i (AS/400).
PMS Information Systems
Would you like to react to this message? Create an account in a few clicks or log in to continue.

Types of file relations?

Go down

Types of file relations? Empty Types of file relations?

Post  maran Sat Oct 09, 2010 5:42 pm

FILE TO FILE FILE TO FIELD

Defined as Known by - key
Owned by - Key Qualified by - key
Refers to - ATTR Includes - ATTR
Extended by Has - ATTR

Defined as: Declaration that the file exist and created implicitly by SYNON

Known by: Specifies that the field is a key field. There can be more than one known by relation

Owned by: Defines a parent and child relationship, Eg., Order header and order details (parent key will be copied to the child)

Qualified by: This is a key relation used to qualify a file identifier by one or more variable factors. This is used to find out a close match (Eg., rate, discount, data, etc.). If no redirection is specified it is similar to KNOWN BY

Refers to: Specifies a file refers to another file (Foreign key)

Includes: A file is to include all the fields that have been declared in the structure file

Extended by: Declares a file to be an extension of a file relation. It gives an association between one to one or one to none. Will work only if it is OWNED BY in the second file

Has: Declares a field to be present in a file

RELATION SEQUENCE AT THE TIME OR RESOLVING

Defined as, Owned by, Qualified by, Extended by, Refers to, Has, Includes
maran
maran
Admin

Posts : 442
Join date : 2009-07-24

https://pmsinformationsystem.forumotion.net

Back to top Go down

Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum