<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META NAME="Generator" CONTENT="MS Exchange Server version 6.5.7233.28">
<TITLE>Sequentially Retreiving an Indexed file in the order they were inserted</TITLE>
</HEAD>
<BODY>
<!-- Converted from text/rtf format -->
<P><FONT SIZE=2 FACE="Trebuchet MS">Hi All,</FONT>
</P>
<P><FONT SIZE=2 FACE="Trebuchet MS">I'm searching for a way to sequentially retreive records of an indexed file. </FONT>
</P>
<P><FONT SIZE=2 FACE="Trebuchet MS">I want to retreive the records in the order they were inserted regardless of the primary index.</FONT>
</P>
<P><FONT SIZE=2 FACE="Trebuchet MS">Using SELECT instead of CHOOSE don't do the job.</FONT>
<BR><FONT SIZE=2 FACE="Trebuchet MS">We use 7.10.E</FONT>
<BR><FONT SIZE=2 FACE="Trebuchet MS">with OpenVMS V6.2 on Vax.</FONT>
</P>
<P><FONT SIZE=2 FACE="Trebuchet MS">I fear that the RMS organization forces usage of the primary index if none mentionned.</FONT>
</P>
<P><FONT SIZE=2 FACE="Trebuchet MS">I tried to read the file in VMSBasic without mentionning any index but the primary is still used anyway.</FONT>
</P>
<P><FONT SIZE=2 FACE="Trebuchet MS">The FDL of the file is at the end of this mail.</FONT>
</P>
<P><FONT SIZE=2 FACE="Trebuchet MS">Thanks for your help.</FONT>
</P>
<P><FONT SIZE=2 FACE="Trebuchet MS">Regards</FONT>
</P>
<P><U><B><FONT SIZE=2 FACE="Trebuchet MS"></FONT></B> <FONT SIZE=2 FACE="Trebuchet MS"> </FONT></U>
<BR><FONT SIZE=2 FACE="Trebuchet MS">Pierre McLeod Tremblay</FONT>
<BR><FONT SIZE=2 FACE="Trebuchet MS">Consultant T.I. / I.T. Consultant</FONT>
<BR><FONT SIZE=2 FACE="Trebuchet MS">pmcleod@videotron.ca</FONT>
<BR><FONT SIZE=2 FACE="Trebuchet MS">819.263.0791 fax: 819.263.0792</FONT>
<BR><FONT SIZE=2 FACE="Trebuchet MS"> cell: 819.692.6666</FONT>
</P>
<P><FONT SIZE=2 FACE="Trebuchet MS">Chez Hydro:</FONT>
<BR><FONT SIZE=2 FACE="Trebuchet MS">tremblay.pierre-mcleod@hydro.qc.ca</FONT>
<BR><FONT SIZE=2 FACE="Trebuchet MS">819.298.2943 poste 7411</FONT>
</P>
<BR>
<BR>
<BR>
<P><FONT SIZE=2 FACE="Trebuchet MS">== FDL ============================</FONT>
<BR><FONT SIZE=2 FACE="Trebuchet MS">SYSTEM</FONT>
<BR><FONT SIZE=2 FACE="Trebuchet MS"> SOURCE VAX/VMS</FONT>
</P>
<P><FONT SIZE=2 FACE="Trebuchet MS">FILE</FONT>
<BR><FONT SIZE=2 FACE="Trebuchet MS"> ALLOCATION 2490</FONT>
<BR><FONT SIZE=2 FACE="Trebuchet MS"> BEST_TRY_CONTIGUOUS yes</FONT>
<BR><FONT SIZE=2 FACE="Trebuchet MS"> BUCKET_SIZE 2</FONT>
<BR><FONT SIZE=2 FACE="Trebuchet MS"> CLUSTER_SIZE 3</FONT>
<BR><FONT SIZE=2 FACE="Trebuchet MS"> CONTIGUOUS no</FONT>
<BR><FONT SIZE=2 FACE="Trebuchet MS"> EXTENSION 0</FONT>
<BR><FONT SIZE=2 FACE="Trebuchet MS"> FILE_MONITORING no</FONT>
<BR><FONT SIZE=2 FACE="Trebuchet MS"> GLOBAL_BUFFER_COUNT 0</FONT>
<BR><FONT SIZE=2 FACE="Trebuchet MS"> NAME "DISK$_RADAPP_:[TDRPROD1.DAT]TDR15.DAT;24"</FONT>
<BR><FONT SIZE=2 FACE="Trebuchet MS"> ORGANIZATION indexed</FONT>
<BR><FONT SIZE=2 FACE="Trebuchet MS"> OWNER [50,177774]</FONT>
<BR><FONT SIZE=2 FACE="Trebuchet MS"> PROTECTION (system:RWED, owner:RWED, group:RW, world:RW)</FONT>
</P>
<P><FONT SIZE=2 FACE="Trebuchet MS">RECORD</FONT>
<BR><FONT SIZE=2 FACE="Trebuchet MS"> BLOCK_SPAN yes</FONT>
<BR><FONT SIZE=2 FACE="Trebuchet MS"> CARRIAGE_CONTROL carriage_return</FONT>
<BR><FONT SIZE=2 FACE="Trebuchet MS"> FORMAT fixed</FONT>
<BR><FONT SIZE=2 FACE="Trebuchet MS"> SIZE 100</FONT>
</P>
<P><FONT SIZE=2 FACE="Trebuchet MS">AREA 0</FONT>
<BR><FONT SIZE=2 FACE="Trebuchet MS"> ALLOCATION 2490</FONT>
<BR><FONT SIZE=2 FACE="Trebuchet MS"> BEST_TRY_CONTIGUOUS yes</FONT>
<BR><FONT SIZE=2 FACE="Trebuchet MS"> BUCKET_SIZE 2</FONT>
<BR><FONT SIZE=2 FACE="Trebuchet MS"> CONTIGUOUS yes</FONT>
<BR><FONT SIZE=2 FACE="Trebuchet MS"> EXTENSION 0</FONT>
</P>
<P><FONT SIZE=2 FACE="Trebuchet MS">KEY 0</FONT>
<BR><FONT SIZE=2 FACE="Trebuchet MS"> CHANGES no</FONT>
<BR><FONT SIZE=2 FACE="Trebuchet MS"> DATA_KEY_COMPRESSION yes</FONT>
<BR><FONT SIZE=2 FACE="Trebuchet MS"> DATA_RECORD_COMPRESSION yes</FONT>
<BR><FONT SIZE=2 FACE="Trebuchet MS"> DATA_AREA 0</FONT>
<BR><FONT SIZE=2 FACE="Trebuchet MS"> DATA_FILL 100</FONT>
<BR><FONT SIZE=2 FACE="Trebuchet MS"> DUPLICATES no</FONT>
<BR><FONT SIZE=2 FACE="Trebuchet MS"> INDEX_AREA 0</FONT>
<BR><FONT SIZE=2 FACE="Trebuchet MS"> INDEX_COMPRESSION yes</FONT>
<BR><FONT SIZE=2 FACE="Trebuchet MS"> INDEX_FILL 100</FONT>
<BR><FONT SIZE=2 FACE="Trebuchet MS"> LEVEL1_INDEX_AREA 0</FONT>
<BR><FONT SIZE=2 FACE="Trebuchet MS"> NAME "D_REJET"</FONT>
<BR><FONT SIZE=2 FACE="Trebuchet MS"> NULL_KEY no</FONT>
<BR><FONT SIZE=2 FACE="Trebuchet MS"> PROLOG 3</FONT>
<BR><FONT SIZE=2 FACE="Trebuchet MS"> SEG0_LENGTH 8</FONT>
<BR><FONT SIZE=2 FACE="Trebuchet MS"> SEG0_POSITION 0</FONT>
<BR><FONT SIZE=2 FACE="Trebuchet MS"> TYPE dstring</FONT>
</P>
<P><FONT SIZE=2 FACE="Trebuchet MS">KEY 1</FONT>
<BR><FONT SIZE=2 FACE="Trebuchet MS"> CHANGES yes</FONT>
<BR><FONT SIZE=2 FACE="Trebuchet MS"> DATA_KEY_COMPRESSION yes</FONT>
<BR><FONT SIZE=2 FACE="Trebuchet MS"> DATA_AREA 0</FONT>
<BR><FONT SIZE=2 FACE="Trebuchet MS"> DATA_FILL 100</FONT>
<BR><FONT SIZE=2 FACE="Trebuchet MS"> DUPLICATES yes</FONT>
<BR><FONT SIZE=2 FACE="Trebuchet MS"> INDEX_AREA 0</FONT>
<BR><FONT SIZE=2 FACE="Trebuchet MS"> INDEX_COMPRESSION yes</FONT>
<BR><FONT SIZE=2 FACE="Trebuchet MS"> INDEX_FILL 100</FONT>
<BR><FONT SIZE=2 FACE="Trebuchet MS"> LEVEL1_INDEX_AREA 0</FONT>
<BR><FONT SIZE=2 FACE="Trebuchet MS"> NAME "ANNEE_PERIODE"</FONT>
<BR><FONT SIZE=2 FACE="Trebuchet MS"> NULL_KEY no</FONT>
<BR><FONT SIZE=2 FACE="Trebuchet MS"> SEG0_LENGTH 6</FONT>
<BR><FONT SIZE=2 FACE="Trebuchet MS"> SEG0_POSITION 80</FONT>
<BR><FONT SIZE=2 FACE="Trebuchet MS"> SEG1_LENGTH 2</FONT>
<BR><FONT SIZE=2 FACE="Trebuchet MS"> SEG1_POSITION 86</FONT>
<BR><FONT SIZE=2 FACE="Trebuchet MS"> TYPE dstring</FONT>
</P>
<P><FONT SIZE=2 FACE="Trebuchet MS">KEY 2</FONT>
<BR><FONT SIZE=2 FACE="Trebuchet MS"> CHANGES yes</FONT>
<BR><FONT SIZE=2 FACE="Trebuchet MS"> DATA_KEY_COMPRESSION yes</FONT>
<BR><FONT SIZE=2 FACE="Trebuchet MS"> DATA_AREA 0</FONT>
<BR><FONT SIZE=2 FACE="Trebuchet MS"> DATA_FILL 100</FONT>
<BR><FONT SIZE=2 FACE="Trebuchet MS"> DUPLICATES yes</FONT>
<BR><FONT SIZE=2 FACE="Trebuchet MS"> INDEX_AREA 0</FONT>
<BR><FONT SIZE=2 FACE="Trebuchet MS"> INDEX_COMPRESSION yes</FONT>
<BR><FONT SIZE=2 FACE="Trebuchet MS"> INDEX_FILL 100</FONT>
<BR><FONT SIZE=2 FACE="Trebuchet MS"> LEVEL1_INDEX_AREA 0</FONT>
<BR><FONT SIZE=2 FACE="Trebuchet MS"> NAME "D_RAP_QUOTIDIEN"</FONT>
<BR><FONT SIZE=2 FACE="Trebuchet MS"> NULL_KEY no</FONT>
<BR><FONT SIZE=2 FACE="Trebuchet MS"> SEG0_LENGTH 8</FONT>
<BR><FONT SIZE=2 FACE="Trebuchet MS"> SEG0_POSITION 45</FONT>
<BR><FONT SIZE=2 FACE="Trebuchet MS"> TYPE dstring</FONT>
</P>
<BR>
<BR>
</BODY>
</HTML>