Re: To Key or Not To Key a Physical

["Chamara Withanachchi" <chamaraw@xxxxxxxxxx>]

As a practice we don't define any key fields in physical files and all our keys (primary,  etc...a) are in logical files. 

We always refer  the logical not the physical. 

But as my opinion it is always good to have a unique, primary key defined in physical file. 

 


 
Regards,

Chamara Withanachchi
IBM Certified Power System Expert
RPG Programmer 
(owner of www.rpgiv.info)
 
WWW.RPGIV.INFO
Mob: +971 50 5698644
Tel: +971 6 5595887
chamaraw@xxxxxxxxxx
www.rpgiv.info 
i want to be future ready. i want control. i want an i.


Sent from my BlackBerry® wireless device

-----Original Message-----
From: Kurt Anderson <kurt.anderson@xxxxxxxxxxxxxx>

Date: Thu, 26 Mar 2009 13:13:30 
To: 'midrange-l@xxxxxxxxxxxx'<midrange-l@xxxxxxxxxxxx>
Subject: To Key or Not To Key a Physical


If I'm going to have multiple logical files over a physical file, is it better to not key the physical file or is there no implication if I do key the physical file (and reduce the number of logicals needed by 1)?

I'm not that familiar with how indexing works, and the concern is that a logical over a keyed physical will be indexing from an index.

Thoughts?

Thanks,

Kurt Anderson
Sr. Programmer/Analyst
CustomCall Data Systems