<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>Sequentially Retreiving an Indexed file in the order they were inserted</TITLE>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2900.2873" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial size=2>another thought, you could try using fdl to create
a sequential version and read that, or you could even try the old quiz command
'dump filename', it might be that this avoids indexes.</FONT></DIV>
<BLOCKQUOTE
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A title=joeboyle_adt@hotmail.com href="mailto:joeboyle_adt@hotmail.com">Joe
Boyle</A> </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A
title=Tremblay.Pierre-McLeod@hydro.qc.ca
href="mailto:Tremblay.Pierre-McLeod@hydro.qc.ca">Tremblay.Pierre-McLeod@hydro.qc.ca</A>
; <A title=powerh-l@lists.sowder.com
href="mailto:powerh-l@lists.sowder.com">powerh-l@lists.sowder.com</A> </DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Tuesday, May 02, 2006 6:51 PM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> Re: Sequentially Retreiving an
Indexed file in the order theywereinserted</DIV>
<DIV><BR></DIV>
<DIV><FONT face=Arial size=2>I always thought that RMS returned records in
that way by default, so unless you are referencing an index via a choose - and
it could be that qtp and quiz use the primary automatically when
there is no choose - I would guess that it would open the first data bucket
and read through the bucket chain to the end of the file, although you would
normally get bucket splits over time so that might present a problem.
</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Have you actually confirmed that the primary
index is being used ?</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>You could always output to disc file and compare
a 'access filename' run with a 'access filename;choose viaindex primarykey'
run, and then use diff to compare them.</FONT></DIV>
<BLOCKQUOTE
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A title=Tremblay.Pierre-McLeod@hydro.qc.ca
href="mailto:Tremblay.Pierre-McLeod@hydro.qc.ca">Tremblay.Pierre-McLeod@hydro.qc.ca</A>
</DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A title=powerh-l@lists.sowder.com
href="mailto:powerh-l@lists.sowder.com">powerh-l@lists.sowder.com</A> </DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Tuesday, May 02, 2006 5:27
PM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> Sequentially Retreiving an
Indexed file in the order they wereinserted</DIV>
<DIV><BR></DIV><!-- Converted from text/rtf format -->
<P><FONT face="Trebuchet MS" size=2>Hi All,</FONT> </P>
<P><FONT face="Trebuchet MS" size=2>I'm searching for a way to sequentially
retreive records of an indexed file. </FONT></P>
<P><FONT face="Trebuchet MS" size=2>I want to retreive the records in the
order they were inserted regardless of the primary index.</FONT> </P>
<P><FONT face="Trebuchet MS" size=2>Using SELECT instead of CHOOSE don't do
the job.</FONT> <BR><FONT face="Trebuchet MS" size=2>We use 7.10.E</FONT>
<BR><FONT face="Trebuchet MS" size=2>with OpenVMS V6.2 on Vax.</FONT> </P>
<P><FONT face="Trebuchet MS" size=2>I fear that the RMS organization forces
usage of the primary index if none mentionned.</FONT> </P>
<P><FONT face="Trebuchet MS" size=2>I tried to read the file in VMSBasic
without mentionning any index but the primary is still used anyway.</FONT>
</P>
<P><FONT face="Trebuchet MS" size=2>The FDL of the file is at the end of
this mail.</FONT> </P>
<P><FONT face="Trebuchet MS" size=2>Thanks for your help.</FONT> </P>
<P><FONT face="Trebuchet MS" size=2>Regards</FONT> </P>
<P><U><B><FONT face="Trebuchet MS" size=2></FONT></B> <FONT
face="Trebuchet MS"
size=2>
</FONT></U><BR><FONT face="Trebuchet MS" size=2>Pierre McLeod
Tremblay</FONT> <BR><FONT face="Trebuchet MS" size=2>Consultant T.I. / I.T.
Consultant</FONT> <BR><FONT face="Trebuchet MS"
size=2>pmcleod@videotron.ca</FONT> <BR><FONT face="Trebuchet MS"
size=2>819.263.0791 fax: 819.263.0792</FONT> <BR><FONT face="Trebuchet MS"
size=2>
cell: 819.692.6666</FONT> </P>
<P><FONT face="Trebuchet MS" size=2>Chez Hydro:</FONT> <BR><FONT
face="Trebuchet MS" size=2>tremblay.pierre-mcleod@hydro.qc.ca</FONT>
<BR><FONT face="Trebuchet MS" size=2>819.298.2943 poste 7411</FONT>
</P><BR><BR><BR>
<P><FONT face="Trebuchet MS" size=2>== FDL
============================</FONT> <BR><FONT face="Trebuchet MS"
size=2>SYSTEM</FONT> <BR><FONT face="Trebuchet MS"
size=2>
SOURCE
VAX/VMS</FONT> </P>
<P><FONT face="Trebuchet MS" size=2>FILE</FONT> <BR><FONT
face="Trebuchet MS" size=2>
ALLOCATION
2490</FONT> <BR><FONT face="Trebuchet MS"
size=2>
BEST_TRY_CONTIGUOUS yes</FONT> <BR><FONT
face="Trebuchet MS" size=2>
BUCKET_SIZE
2</FONT> <BR><FONT face="Trebuchet MS"
size=2>
CLUSTER_SIZE
3</FONT> <BR><FONT face="Trebuchet MS"
size=2>
CONTIGUOUS
no</FONT> <BR><FONT face="Trebuchet MS"
size=2>
EXTENSION
0</FONT> <BR><FONT face="Trebuchet MS"
size=2>
FILE_MONITORING no</FONT>
<BR><FONT face="Trebuchet MS"
size=2>
GLOBAL_BUFFER_COUNT 0</FONT> <BR><FONT
face="Trebuchet MS" size=2>
NAME
"DISK$_RADAPP_:[TDRPROD1.DAT]TDR15.DAT;24"</FONT> <BR><FONT
face="Trebuchet MS" size=2>
ORGANIZATION
indexed</FONT> <BR><FONT face="Trebuchet MS"
size=2>
OWNER
[50,177774]</FONT> <BR><FONT face="Trebuchet MS"
size=2>
PROTECTION
(system:RWED, owner:RWED, group:RW, world:RW)</FONT> </P>
<P><FONT face="Trebuchet MS" size=2>RECORD</FONT> <BR><FONT
face="Trebuchet MS" size=2>
BLOCK_SPAN
yes</FONT> <BR><FONT face="Trebuchet MS"
size=2>
CARRIAGE_CONTROL
carriage_return</FONT> <BR><FONT face="Trebuchet MS"
size=2>
FORMAT
fixed</FONT> <BR><FONT face="Trebuchet MS"
size=2>
SIZE
100</FONT> </P>
<P><FONT face="Trebuchet MS" size=2>AREA 0</FONT> <BR><FONT
face="Trebuchet MS" size=2>
ALLOCATION
2490</FONT> <BR><FONT face="Trebuchet MS"
size=2>
BEST_TRY_CONTIGUOUS yes</FONT> <BR><FONT
face="Trebuchet MS" size=2>
BUCKET_SIZE
2</FONT> <BR><FONT face="Trebuchet MS"
size=2>
CONTIGUOUS
yes</FONT> <BR><FONT face="Trebuchet MS"
size=2>
EXTENSION
0</FONT> </P>
<P><FONT face="Trebuchet MS" size=2>KEY 0</FONT> <BR><FONT
face="Trebuchet MS" size=2>
CHANGES
no</FONT> <BR><FONT face="Trebuchet MS"
size=2>
DATA_KEY_COMPRESSION yes</FONT> <BR><FONT
face="Trebuchet MS" size=2>
DATA_RECORD_COMPRESSION yes</FONT> <BR><FONT face="Trebuchet MS"
size=2>
DATA_AREA
0</FONT> <BR><FONT face="Trebuchet MS"
size=2>
DATA_FILL
100</FONT> <BR><FONT face="Trebuchet MS"
size=2>
DUPLICATES
no</FONT> <BR><FONT face="Trebuchet MS"
size=2>
INDEX_AREA
0</FONT> <BR><FONT face="Trebuchet MS"
size=2>
INDEX_COMPRESSION yes</FONT> <BR><FONT
face="Trebuchet MS" size=2>
INDEX_FILL
100</FONT> <BR><FONT face="Trebuchet MS"
size=2>
LEVEL1_INDEX_AREA 0</FONT> <BR><FONT
face="Trebuchet MS" size=2>
NAME
"D_REJET"</FONT> <BR><FONT face="Trebuchet MS"
size=2>
NULL_KEY
no</FONT> <BR><FONT face="Trebuchet MS"
size=2>
PROLOG
3</FONT> <BR><FONT face="Trebuchet MS"
size=2>
SEG0_LENGTH
8</FONT> <BR><FONT face="Trebuchet MS"
size=2>
SEG0_POSITION
0</FONT> <BR><FONT face="Trebuchet MS"
size=2>
TYPE
dstring</FONT> </P>
<P><FONT face="Trebuchet MS" size=2>KEY 1</FONT> <BR><FONT
face="Trebuchet MS" size=2>
CHANGES
yes</FONT> <BR><FONT face="Trebuchet MS"
size=2>
DATA_KEY_COMPRESSION yes</FONT> <BR><FONT
face="Trebuchet MS" size=2>
DATA_AREA
0</FONT> <BR><FONT face="Trebuchet MS"
size=2>
DATA_FILL
100</FONT> <BR><FONT face="Trebuchet MS"
size=2>
DUPLICATES
yes</FONT> <BR><FONT face="Trebuchet MS"
size=2>
INDEX_AREA
0</FONT> <BR><FONT face="Trebuchet MS"
size=2>
INDEX_COMPRESSION yes</FONT> <BR><FONT
face="Trebuchet MS" size=2>
INDEX_FILL
100</FONT> <BR><FONT face="Trebuchet MS"
size=2>
LEVEL1_INDEX_AREA 0</FONT> <BR><FONT
face="Trebuchet MS" size=2>
NAME
"ANNEE_PERIODE"</FONT> <BR><FONT face="Trebuchet MS"
size=2>
NULL_KEY
no</FONT> <BR><FONT face="Trebuchet MS"
size=2>
SEG0_LENGTH
6</FONT> <BR><FONT face="Trebuchet MS"
size=2>
SEG0_POSITION
80</FONT> <BR><FONT face="Trebuchet MS"
size=2>
SEG1_LENGTH
2</FONT> <BR><FONT face="Trebuchet MS"
size=2>
SEG1_POSITION
86</FONT> <BR><FONT face="Trebuchet MS"
size=2>
TYPE
dstring</FONT> </P>
<P><FONT face="Trebuchet MS" size=2>KEY 2</FONT> <BR><FONT
face="Trebuchet MS" size=2>
CHANGES
yes</FONT> <BR><FONT face="Trebuchet MS"
size=2>
DATA_KEY_COMPRESSION yes</FONT> <BR><FONT
face="Trebuchet MS" size=2>
DATA_AREA
0</FONT> <BR><FONT face="Trebuchet MS"
size=2>
DATA_FILL
100</FONT> <BR><FONT face="Trebuchet MS"
size=2>
DUPLICATES
yes</FONT> <BR><FONT face="Trebuchet MS"
size=2>
INDEX_AREA
0</FONT> <BR><FONT face="Trebuchet MS"
size=2>
INDEX_COMPRESSION yes</FONT> <BR><FONT
face="Trebuchet MS" size=2>
INDEX_FILL
100</FONT> <BR><FONT face="Trebuchet MS"
size=2>
LEVEL1_INDEX_AREA 0</FONT> <BR><FONT
face="Trebuchet MS" size=2>
NAME
"D_RAP_QUOTIDIEN"</FONT> <BR><FONT face="Trebuchet MS"
size=2>
NULL_KEY
no</FONT> <BR><FONT face="Trebuchet MS"
size=2>
SEG0_LENGTH
8</FONT> <BR><FONT face="Trebuchet MS"
size=2>
SEG0_POSITION
45</FONT> <BR><FONT face="Trebuchet MS"
size=2>
TYPE
dstring</FONT> </P><BR><BR>
<P>
<HR>
<P></P>-- <BR>= = = = = = = = = = = = = = = = = = = = = = = = = = =
=<BR>Mailing list: powerh-l@lists.sowder.com<BR>Subscribe:
&quot;subscribe&quot; in message body to
powerh-l-request@lists.sowder.com<BR>Unsubscribe: &quot;unsubscribe
&lt;password&gt;&quot; in message body to
powerh-l-request@lists.sowder.com<BR>http://lists.sowder.com/mailman/listinfo/powerh-l<BR>This
list is closed, thus to post to the list you must be a subscriber.<BR>Add
'site:lists.sowder.com powerh-l' to your search terms to search the list
archive at Google.</BLOCKQUOTE>
<P>
<HR>
<P></P>-- <BR>= = = = = = = = = = = = = = = = = = = = = = = = = = =
=<BR>Mailing list: powerh-l@lists.sowder.com<BR>Subscribe:
&quot;subscribe&quot; in message body to
powerh-l-request@lists.sowder.com<BR>Unsubscribe: &quot;unsubscribe
&lt;password&gt;&quot; in message body to
powerh-l-request@lists.sowder.com<BR>http://lists.sowder.com/mailman/listinfo/powerh-l<BR>This
list is closed, thus to post to the list you must be a subscriber.<BR>Add
'site:lists.sowder.com powerh-l' to your search terms to search the list
archive at Google.</BLOCKQUOTE></BODY></HTML>