RE: Advantages/Disadvantages of not defining KEYS in a physicalf ile

Giri,

<g> This is one of those 'holy war' topics, albeit this one is as old as the
hills (or the S38, whichever came first...). IMO, it is correct to key the
physical file. Originally, the argument against using keys on the PF were
primarily performance related, and are not at all applicable to today's
iSeries. 

Eric DeLong
Sally Beauty Company
MIS-Sr. Programmer/Analyst
940-898-7863 or ext. 1863
 


-----Original Message-----
From: Giri Gopal [mailto:girigopal@bcgink.com]
Sent: Monday, July 16, 2001 8:03 AM
To: RPG400-L@midrange.com
Subject: RE: Advantages/Disadvantages of not defining KEYS in a physical
file


DDS tables and yes 45% are Journaled.


-----Original Message-----
From: owner-rpg400-l@midrange.com [mailto:owner-rpg400-l@midrange.com]On
Behalf Of Andrew.Lutz@abbott.com
Sent: Friday, July 13, 2001 4:14 PM
To: RPG400-L@midrange.com
Subject: Re: Advantages/Disadvantages of not defining KEYS in a physical
file



More information please:

     SQL table or DDS?
     Journaled or not?






                    "Giri Gopal"
                    <girigopal@bcgink        To:     <RPG400-L@midrange.com>
                    .com>                    cc:
                    Sent by:                 Subject:
Advantages/Disadvantages of not defining KEYS in a physical
                    owner-rpg400-l@mi        file
                    drange.com


                    07/13/2001 02:56
                    PM
                    Please respond to
                    RPG400-L







Hi:

Can someone give me a list of advantages/disadvantages of defining key
fields in  physcial file.

Thanks for your help in advance.
Giri

+---
| This is the RPG/400 Mailing List!
| To submit a new message, send your mail to RPG400-L@midrange.com.
| To subscribe to this list send email to RPG400-L-SUB@midrange.com.
| To unsubscribe from this list send email to RPG400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator:
david@midrange.com
+---




+---
| This is the RPG/400 Mailing List!
| To submit a new message, send your mail to RPG400-L@midrange.com.
| To subscribe to this list send email to RPG400-L-SUB@midrange.com.
| To unsubscribe from this list send email to RPG400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator:
david@midrange.com
+---

+---
| This is the RPG/400 Mailing List!
| To submit a new message, send your mail to RPG400-L@midrange.com.
| To subscribe to this list send email to RPG400-L-SUB@midrange.com.
| To unsubscribe from this list send email to RPG400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator:
david@midrange.com
+---

+---
| This is the RPG/400 Mailing List!
| To submit a new message, send your mail to RPG400-L@midrange.com.
| To subscribe to this list send email to RPG400-L-SUB@midrange.com.
| To unsubscribe from this list send email to RPG400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---