<!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><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">to don my pedantic hat, I
will say this - from my perspective I see this facility as a list, presumably a
bit like a 'chat room' ( although I don't know what a chat room is like in any
detail ). The point I am making is as follows, when I respond to a
question on the list, I am offering a suggestion, something to test
perhaps, I do not give advice - this is the domain of the Cognos
techies.</SPAN></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 7:10 PM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> RE: Sequentially Retreiving an
Indexed file in the ordertheywereinserted</DIV>
<DIV><BR></DIV>
<DIV><SPAN class=240300618-02052006><FONT face="Trebuchet MS" color=#0000ff
size=2>Guy,</FONT></SPAN></DIV>
<DIV><SPAN class=240300618-02052006><FONT face="Trebuchet MS" color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=240300618-02052006><FONT face="Trebuchet MS" color=#0000ff
size=2>The file I'm tring to retreive in that order already
exists.</FONT></SPAN></DIV>
<DIV><SPAN class=240300618-02052006><FONT face="Trebuchet MS" color=#0000ff
size=2>We are in the process of migrating from PowerHouse to LabWare for our
Laboratory data.</FONT></SPAN></DIV>
<DIV><SPAN class=240300618-02052006><FONT face="Trebuchet MS" color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=240300618-02052006><FONT face="Trebuchet MS" color=#0000ff
size=2>I will try a FDL conversion to a sequential file and see if it's
work. Joe Boyle gave me that advice.</FONT></SPAN></DIV>
<DIV><SPAN class=240300618-02052006><FONT face="Trebuchet MS" color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=240300618-02052006><FONT face="Trebuchet MS" color=#0000ff
size=2>McLeod</FONT></SPAN></DIV>
<DIV><SPAN class=240300618-02052006><FONT face="Trebuchet MS" color=#0000ff
size=2></FONT></SPAN> </DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-----Message d'origine-----<BR><B>De :</B> <A
href="mailto:powerh-l-bounces+tremblay.pierre-mcleod=hydro.qc.ca@lists.sowder.com">powerh-l-bounces+tremblay.pierre-mcleod=hydro.qc.ca@listssowder.com</A>
[mailto:powerh-l-bounces+tremblay.pierre-mcleod=hydro.qc.ca@lists.sowder.com]<B>De
la part de</B> Guy Werry<BR><B>Envoyé :</B> 2 mai 2006
12:47<BR><B>À :</B> powerh-l@lists.sowder.com<BR><B>Objet :</B>
RE: Sequentially Retreiving an Indexed file in the order
theywereinserted<BR><BR></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=216094216-02052006>Pierre,</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=216094216-02052006></SPAN></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=216094216-02052006>I'm working from HP-Ux knowledge here, but this
should be similar to what happens under RMS.</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=216094216-02052006></SPAN></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=216094216-02052006>In
C-ISAM Powerhouse will always follow the <U>primary</U> index. About
the only way to do what you want is to:</SPAN></FONT></DIV>
<OL>
<LI><FONT face=Arial color=#0000ff size=2><SPAN
class=216094216-02052006>Have a <U>sequential</U> file that is not
indexed</SPAN></FONT>
<LI><FONT face=Arial color=#0000ff size=2><SPAN
class=216094216-02052006>Set an index on your indexed file that will
capture the order of insert: for example, a time stamp,
YYYYMMDD:HHSS.</SPAN></FONT>
<LI><FONT face=Arial color=#0000ff size=2><SPAN
class=216094216-02052006>If you have a timestamp that's not an index then
you can SORT on that timestamp ... performance suffers, but it will
work.</SPAN></FONT></LI></OL>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=216094216-02052006>Hope that helps!</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=216094216-02052006><FONT size=2></FONT></SPAN></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=216094216-02052006><FONT size=2>Guy L. Werry<BR>Senior Systems
Analyst<BR>Hudson Bay Mining & Smelting Co., Limited.
</FONT></DIV></SPAN></FONT>
<BLOCKQUOTE>
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B>
powerh-l-bounces+guy.werry=hbms.ca@lists.sowder.com
[mailto:powerh-l-bounces+guy.werry=hbms.ca@lists.sowder.com]<B>On Behalf
Of </B>Tremblay.Pierre-McLeod@hydro.qc.ca<BR><B>Sent:</B> Tuesday, May 02,
2006 11:27 AM<BR><B>To:</B> powerh-l@lists.sowder.com<BR><B>Subject:</B>
Sequentially Retreiving an Indexed file in the order they
wereinserted<BR><BR></DIV></FONT><!-- 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></BLOCKQUOTE></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>