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

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

What is access path? How many types & explain each.

View previous topic View next topic Go down

What is access path? How many types & explain each.

Post  maran on Sat Oct 09, 2010 5:52 pm

Access path is path through which you can retrieve records. There are 6 types of access path is
supported by SYNON. By default Synon creates 3 access path namely Physical, Update and
Retrieve access paths.

1. ‘PHY’: Physical file: Arrival sequence access path defining the based-on file. For a given
AllFusion 2E file there may only be one access path of type PHY - the path will automatically be
created by AllFusion 2E.

2. ‘UPD’: Update: Access path used for update. Path is keyed on AllFusion 2E fields that identify
the file. For a given AllFusion 2E file there may be several different access paths of type
UPD, each containing a different combination of fields. A default update path containing all
fields will automatically be created by AllFusion 2E.

3. ‘RTV’: Retrieval: Access path used to retrieve records from file. The key order cannot be
changed. For a given AllFusion 2E file there may be many access path of type RTV - a default
path, keyed on the identifying fields for the file, will automatically be created by AllFusion 2E.
Each ‘RTV’ access path has an associated 'UPD' access path.

4. ‘RSQ’: Resequence: Access path used to retrieve records from file using an alternative key
order. For a given AllFusion 2E file there may be many access paths of type 'RSQ'.

5. 'QRY' : Query: Access path used to retrieve records from file using an alternative key
order which may include virtual fields. For a given AllFusion 2E file there may be many
access paths of type 'QRY'.

6. ‘SPN’: Span: Access path used to span several different files using an alternative key order.
For a given AllFusion 2E file there may be many access paths of type 'SPN'.
avatar
maran
Admin

Posts : 442
Join date : 2009-07-24

View user profile http://pmsinformationsystem.forumotion.net

Back to top Go down

View previous topic View next topic Back to top

- Similar topics

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