• Subject: RE: PF File Definition questions...
  • From: Buck Calabro <mcalabro@xxxxxxxxxxxx>
  • Date: Fri, 15 Oct 1999 15:49:39 -0400

I knew there'd be an explanation.  So even if you started out with an
arrival sequence file, after the ADDPFCST you'd have a keyed physical.
Makes sense, based on the idea that RI is all done with the keys, not with
the data.

Thanks Rob!

Buck Calabro

> -----Original Message-----
> From: Rob Berendt 
> Sent: Friday, October 15, 1999 2:43 PM
> To:   MIDRANGE-L@midrange.com
> Subject:      RE: PF File Definition questions...
> 
> By adding the PFCST of *prikey you've added a key to the physical 
> file, hence the key on *prikey.
> 
-snip-

>   Access path . . . . . . . . . . . . . . . . :            Keyed   
>   Access path size  . . . . . . . . . . . . . : ACCPTHSIZ  *MAX1TB 
>   Maximum key length  . . . . . . . . . . . . :               5    
>   Maximum record length . . . . . . . . . . . :               15   
>   File is currently journaled . . . . . . . . :            No      
> Access Path Description                                            
>   Access path maintenance . . . . . . . . . . : MAINT      *IMMED  
>   Unique key values required  . . . . . . . . : UNIQUE     Yes     
>   Access path journaled . . . . . . . . . . . :            No      
>   Access path . . . . . . . . . . . . . . . . :            Keyed   
>   Constraint Type . . . . . . . . . . . . . . :            PRIMARY 
> 
-snip-

> mcalabro@commsoft.net on 10/15/99 01:26:38 PM
> 
> I am fairly new to RI, so I had to try this.  
> 
-snip about creating a non-keyed PF and adding RI to it-

> Buck Calabro
> 
> > -----Original Message-----
> > From:       Rob Berendt 
> > Sent:       Friday, October 15, 1999 10:00 AM
> > To: MIDRANGE-L@midrange.com
> > Subject:    Re: PF File Definition questions...
> > 
> > Most of our package PF's do not have a key.  Any new ones I create, 
> > do.  I am trying to follow database rules.  You cannot do Referential 
> > Integrity on files without a primary key.
+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2019 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].