Sequentially Retreiving an Indexed file in theordertheywereinserted

[Olson, Ingemar]

RMS stores data records in an indexed file according to the primary key value.
If you need to access them in a different sequence you'll have to add a key or sort them on some data field(s) that represent the sequence you want.
If you have timestamp information stored in the data records, eg, then you have the possibility of creating a new index using these fields.
If there is no such information then this is just not possible.

Ingemar Olson 
Dairyland IT Department, Sperling   
SAPUTO FOODS LIMITED 

-----Original Message-----
From: powerh-l-bounces+iolson=saputo.com at lists.sowder.com [mailto:powerh-l-bounces+iolson=saputo.com at lists.sowder.com]On Behalf Of Tremblay.Pierre-McLeod at hydro.qc.ca
Sent: May 2, 2006 11:35
To: powerh-l at lists.sowder.com
Subject: RE: Sequentially Retreiving an Indexed file in theordertheywereinserted


Roger,
 
I will try it but I have little hope.
 
I just converted the file to a sequential one using convert file/fdl....
And still, records are presented the way of the former primary index.
 
Pierre
 

-----Message d'origine-----
De : Roger Kesterson [mailto:Roger.Kesterson at mtdproducts.com]
Envoyé : 2 mai 2006 14:23
À : Tremblay, Pierre McLeod
Objet : RE: Sequentially Retreiving an Indexed file in the ordertheywereinserted



Actually, I guess you wouldn't even need to use a logical, you could just use the same VMS file spec for the sequential file as for the indexed one...

 


  _____  


From: Roger Kesterson 
Sent: Tuesday, May 02, 2006 11:18 AM
To: 'Tremblay.Pierre-McLeod at hydro.qc.ca'
Subject: RE: Sequentially Retreiving an Indexed file in the ordertheywereinserted

 

Pierre,

 

I think what Joe was getting at is to define a sequential file in PowerHouse and point it to the indexed file using a logical.

 

I think...

 

Regards,

Roger Kesterson

 

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.sowder.com/pipermail/powerh-l/attachments/20060502/50e07c0f/attachment.html