QDESIGN file types and cluster control (PH607F on AS/400)
Daniel Mielke
DMielke@aic.com
Fri, 3 May 2002 15:03:01 -0400
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_001_01C1F2D5.25415900
Content-Type: text/plain;
charset="iso-8859-1"
Joe,
As far as I know 607F on AS/400 does not have the 'order by' syntax and thus
the reads are in index order only. As for subfiles, that option is also not
available for AS/400.
I can create a new index for RATLETS to sort by Status/RAT/RATLET so that
when RATLET-RACES is retrieved in RATLET sequence, it will coincide with
RATLETS. The alternative is to build a screen to list RATLETS only and a
subscreen to list RATLET-RACES for a given RATLET.
Sucks to be me on an AS/400. I wonder if Richard, George, Alan or other
AS/400 607Fers have encountered this problem.
-----Original Message-----
From: Boyle, Joe [mailto:Joe.Boyle@cognos.com]
Sent: Friday, May 03, 2002 4:13 AM
To: 'Daniel Mielke'
Cc: Powerhouse List (E-mail)
Subject: RE: QDESIGN file types and cluster control (PH607F on AS/400)
Hi Daniel,
I am not familiar with the 'HOLD FIND' syntax so now I am wild guessing,
suggestion 1,
is that you try the syntax I sent without the 'HOLD FIND' syntax
suggestion 2,
is there no 'order by' syntax that you could use to return the primary rows
in order 305, 321, 333 ?
suggestion 3,
you could call quiz from the path procedure to write the primary file rows
you are interested in to a subfile sorting on the order you want, you would
then access the subfile as the primary file,
using suggestion 1, I believe that you should see the 3 consecutive screens
below ( pressing return after each primary is displayed ), but I am not sure
of your setup so this is another guess on my part; although it is what I see
with Oracle on both Axiant on NT and Quick on Unix.
scr1________________________________________________________________________
RATS
rat-no rat-name ratlets
1 Big MOMMA RAT 10
RATLETS (index for ratlet-no and index for ratlet-status)
ratlet-no rat-no ratlet-name ratlet-status Termination-reason
lots of ratlets... mostly Dead thus the status index
321 1 Bobby Ray Alive
RATLET-RACES (index for ratlet-no)
ratlet-no race-no win-lose income
321 1244 W $75.00
321 1255 W $45.00
scr2________________________________________________________________________
RATS
rat-no rat-name ratlets
1 Big MOMMA RAT 10
RATLETS (index for ratlet-no and index for ratlet-status)
ratlet-no rat-no ratlet-name ratlet-status Termination-reason
lots of ratlets... mostly Dead thus the status index
333 1 Billy Bob Alive
RATLET-RACES (index for ratlet-no)
ratlet-no race-no win-lose income
333 1523 L $0.00
333 1627 L $0.00
333 1655 L $0.00
scr3________________________________________________________________________
RATS
rat-no rat-name ratlets
1 Big MOMMA RAT 10
RATLETS (index for ratlet-no and index for ratlet-status)
ratlet-no rat-no ratlet-name ratlet-status Termination-reason
lots of ratlets... mostly Dead thus the status index
305 1 Benjamin Alive
RATLET-RACES (index for ratlet-no)
ratlet-no race-no win-lose income
305 1234 W $100.00
305 1355 W $50.00
305 1425 L $0.00
-----Original Message-----
From: Daniel Mielke [mailto:DMielke@aic.com]
Sent: 02 May 2002 17:28
To: 'Boyle, Joe'
Cc: Powerhouse List (E-mail)
Subject: RE: QDESIGN file types and cluster control (PH607F on AS/400)
Hi Joe,
The HOLD FIND statement applies to the PRIMARY file if no DETAIL file exists
and causes QUICK to "read into" the PRIMARY/DETAIL files. In this case a
DETAIL file exists and the access is "sequential" using the specific index.
If the PRIMARY file does not supply the indexed field in the DETAIL file in
the sequence of the DETAIL file, QUICK does not reset its search to start
from the beginning of the DETAIL file. In the example, the screen would
display RATLETS 321 and 333 and stop. Scrolling back would retrieve 305.
I'm looking for all three. Thoughts?
RATS
rat-no rat-name ratlets
1 Big MOMMA RAT 10
RATLETS (index for ratlet-no and index for ratlet-status)
ratlet-no rat-no ratlet-name ratlet-status Termination-reason
lots of ratlets... mostly Dead thus the status index
321 1 Bobby Ray Alive
333 1 Billy Bob Alive
305 1 Benjamin Alive
RATLET-RACES (index for ratlet-no)
ratlet-no race-no win-lose income
305 1234 W $100.00
305 1355 W $50.00
305 1425 L $0.00
321 1244 W $75.00
321 1255 W $45.00
333 1523 L $0.00
333 1627 L $0.00
333 1655 L $0.00
-----Original Message-----
From: Boyle, Joe [mailto:Joe.Boyle@cognos.com]
Sent: Thursday, May 02, 2002 4:57 AM
To: 'Daniel Mielke'; Powerhouse List (E-mail)
Subject: RE: QDESIGN file types and cluster control (PH607F on AS/400)
Hi Daniel,
how about something like that below, on receiving a rat the user can scroll
through ratlets ( by pressing return ), listing the ratrace details for each
ratlet,
can cle
SCREEN Screen4 RECEIVING RATS
FILE RATS IN mydbst MASTER
FILE RATLETS IN mydbst PRIMARY
ACCESS USING order_no of RATS VIA order_no
FILE RAT_RACES IN mydbst detail OCCURS 10
Item ORDER_NO_C final ascii( ORDER_NO OF RATS ,10)
Item ORDER_LINE_NO_C final ascii( ORDER_LINE_NO OF RAT_RACES ,4)
ACCESS USING order_no of RATLETS VIA order_no
FIELD ORDER_NO OF RATS DISPLAY PREDISPLAY
FIELD ORDER_LINE_NO OF RATLETS DISPLAY PREDISPLAY
align ( 1,,4 ) ( ,,20 ) ( ,,50 )
CLUSTER OCCURS WITH RAT_RACES
FIELD ORDER_LINE_NO OF RAT_RACES REQUIRED NOCHANGE &
LOOKUP NOTON RAT_RACESVIA ORDER_NO, ORDER_LINE_NO USING &
ORDER_NO OF RATS, ORDER_LINE_NO OF RAT_RACES
FIELD ORDER_LN_NAME OF RAT_RACES
FIELD ORDER_LN_BRANCH OF RAT_RACES
CLUSTER
BUILD LIST
regards,
Joe Boyle.
-----Original Message-----
From: Daniel Mielke [ mailto:DMielke@aic.com <mailto:DMielke@aic.com> ]
Sent: 01 May 2002 18:58
To: Powerhouse List (E-mail)
Subject: QDESIGN file types and cluster control (PH607F on AS/400)
Hi Listers,
I'm getting some weird results when building a FIND only screen.
Bear with me on this example(Once again, thanks Chuck!):
I want to list the detail of RATLET-RACES for active RATLETS. The user is
coming into the screen with a RAT record as MASTER. RATLETS is being
retrieved via ratlet-status and selected if rat-no of RAT = rat-no of
RATLETS. RATLET-RACES is a DETAIL file indexed by ratlet-no (matching up to
RATLET). The cluster is based on the occurrence of RATLET-RACES.
There are three active RATLETS. Each RATLETS record has matching
RATLET-RACES records. However the screen displays only two RATLETS and
stops. The scrolling back doesn't work. When the HOLD FIND is removed, the
scrolling back works and gets the third RATLETS record and associated
RATLET-RACES records.
The impression that I get is that QUICK is passing once though RATLET-RACES.
QUICK finds RATLET-RACES for the first RATLETS record, continuing on from
that point to get records for the second RATLETS record, and stopping when
it can't find RATLET-RACES records for third. (RATLETS is not being
retrieved in ratlet-no order)
Is there a way to ?Reset? the access of the detail file for each occurrence
of RATLETS?
Should I change the file structure?
Help!
> BUY. HOLD. AND PROSPER.
>
> Daniel Mielke
> Business Systems Analyst
> AIC Limited
> 1-888-710-4242 (4614)
> dmielke@aic.com
> www.aic.com
>
>
= = = = = = = = = = = = = = = = = = = = = = = = = = = =
Mailing list: powerh-l@lists.swau.edu
Subscribe: "subscribe" in message body to powerh-l-request@lists.swau.edu
Unsubscribe: "unsubscribe" in message body to
powerh-l-request@lists.swau.edu
http://lists.swau.edu/mailman/listinfo/powerh-l
<http://lists.swau.edu/mailman/listinfo/powerh-l>
This list is closed, thus to post to the list you must be a subscriber.
This message may contain privileged and/or confidential information. If you
have received this e-mail in error or are not the intended recipient, you
may not use, copy, disseminate or distribute it; do not open any
attachments, delete it immediately from your system and notify the sender
promptly by e-mail that you have done so. Thank you.
This message may contain privileged and/or confidential information. If you
have received this e-mail in error or are not the intended recipient, you
may not use, copy, disseminate or distribute it; do not open any
attachments, delete it immediately from your system and notify the sender
promptly by e-mail that you have done so. Thank you.
------_=_NextPart_001_01C1F2D5.25415900
Content-Type: text/html;
charset="iso-8859-1"
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<TITLE>RE: QDESIGN file types and cluster control (PH607F on AS/400)</TITLE>
<META content="MSHTML 5.00.2919.6307" name=GENERATOR></HEAD>
<BODY>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=179434615-03052002>Joe,</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=179434615-03052002></SPAN></FONT> </DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN class=179434615-03052002>As far
as I know 607F on AS/400 does not have the 'order by' syntax and thus the reads
are in index order only. As for subfiles, that option is also not
available for AS/400.</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=179434615-03052002></SPAN></FONT> </DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN class=179434615-03052002>I can
create a new index for RATLETS to sort by Status/RAT/RATLET so that when
RATLET-RACES is retrieved in RATLET sequence, it will coincide
with RATLETS. The alternative is to build a screen to
list RATLETS only and a subscreen to list RATLET-RACES for a given
RATLET.</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=179434615-03052002></SPAN></FONT> </DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN class=179434615-03052002>Sucks
to be me on an AS/400. I wonder if Richard, George, Alan or other AS/400
607Fers have encountered this problem.</SPAN></FONT></DIV>
<BLOCKQUOTE style="MARGIN-RIGHT: 0px">
<DIV align=left class=OutlookMessageHeader dir=ltr><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B> Boyle, Joe
[mailto:Joe.Boyle@cognos.com]<BR><B>Sent:</B> Friday, May 03, 2002 4:13
AM<BR><B>To:</B> 'Daniel Mielke'<BR><B>Cc:</B> Powerhouse List
(E-mail)<BR><B>Subject:</B> RE: QDESIGN file types and cluster control (PH607F
on AS/400)<BR><BR></DIV></FONT>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN class=863074407-03052002>Hi
Daniel,</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=863074407-03052002></SPAN></FONT> </DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN class=863074407-03052002>I am
not familiar with the 'HOLD FIND' syntax so now I am wild guessing,
</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=863074407-03052002></SPAN></FONT> </DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=863074407-03052002>suggestion 1, </SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=863074407-03052002></SPAN></FONT><FONT color=#0000ff face=Arial
size=2><SPAN class=863074407-03052002>is that you try the syntax I
sent without the 'HOLD FIND' syntax </SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=863074407-03052002><FONT color=#0000ff face=Arial size=2><SPAN
class=863074407-03052002></SPAN></FONT></SPAN></FONT> </DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=863074407-03052002><FONT color=#0000ff face=Arial size=2><SPAN
class=863074407-03052002>suggestion 2, </SPAN></FONT></SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=863074407-03052002><FONT color=#0000ff face=Arial size=2><SPAN
class=863074407-03052002>i</SPAN></FONT>s there no 'order by' syntax that you
could use to return the primary rows in order 305, 321, 333 ?
</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=863074407-03052002><FONT color=#0000ff face=Arial size=2><SPAN
class=863074407-03052002></SPAN></FONT></SPAN></FONT> </DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=863074407-03052002><FONT color=#0000ff face=Arial size=2><SPAN
class=863074407-03052002>suggestion 3, </SPAN></FONT></SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=863074407-03052002><FONT color=#0000ff face=Arial size=2><SPAN
class=863074407-03052002>you could call quiz from the path procedure to
write the primary file rows you are interested in to a subfile sorting on the
order you want, you would then access the subfile as the primary
file,</SPAN></FONT></SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=863074407-03052002></SPAN></FONT> </DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=863074407-03052002>using <FONT color=#0000ff face=Arial size=2><SPAN
class=863074407-03052002>suggestion 1, </SPAN></FONT>I believe that you
should see the 3 consecutive screens below ( pressing return after each
primary is displayed ), but I am not sure of your setup so this is another
guess on my part; although it is what I see with Oracle on both Axiant on NT
and Quick on Unix. </SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=863074407-03052002></SPAN></FONT> </DIV>
<DIV><SPAN class=863074407-03052002>
<DIV><SPAN class=281384315-02052002></SPAN> </DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=281384315-02052002><SPAN class=863074407-03052002></SPAN><FONT
color=#0000ff face=Arial size=2>s<SPAN
class=863074407-03052002>cr1________________________________________________________________________</SPAN></FONT></SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=863074407-03052002></SPAN> </FONT></DIV>
<DIV>
<BLOCKQUOTE style="MARGIN-RIGHT: 0px">
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=281384315-02052002>RATS</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=281384315-02052002>rat-no rat-name
ratlets</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=281384315-02052002>1 Big
MOMMA RAT 10</SPAN></FONT></DIV>
<DIV><SPAN class=281384315-02052002></SPAN><FONT color=#0000ff face=Arial
size=2> </FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=281384315-02052002>RATLETS (index for ratlet-no and
index for ratlet-status)</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=281384315-02052002>ratlet-no rat-no ratlet-name
ratlet-status Termination-reason</SPAN></FONT></DIV>
<DIV><SPAN class=281384315-02052002></SPAN><FONT color=#0000ff face=Arial
size=2> </FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=281384315-02052002>lots of ratlets... mostly Dead thus the status
index</SPAN></FONT></DIV>
<DIV><SPAN class=281384315-02052002></SPAN><FONT color=#0000ff face=Arial
size=2> </FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=281384315-02052002>321 1 Bobby Ray
Alive</SPAN></FONT></DIV>
<DIV><SPAN class=281384315-02052002></SPAN><FONT color=#0000ff face=Arial
size=2> </FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=281384315-02052002>RATLET-RACES (index for
ratlet-no)</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=281384315-02052002>ratlet-no race-no win-lose income</SPAN></FONT></DIV>
<DIV> </DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=281384315-02052002>321 1244 W $75.00</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=281384315-02052002>321 1255 W $45.00</SPAN></FONT></DIV></BLOCKQUOTE>
<DIV> </DIV>
<DIV><SPAN class=281384315-02052002></SPAN> </DIV>
<DIV><SPAN class=281384315-02052002>
<DIV><SPAN class=281384315-02052002><SPAN
class=863074407-03052002></SPAN><FONT color=#0000ff face=Arial size=2>s<SPAN
class=863074407-03052002>cr2________________________________________________________________________</SPAN></FONT></SPAN></DIV>
<DIV><SPAN class=281384315-02052002><FONT color=#0000ff face=Arial
size=2><SPAN class=863074407-03052002></SPAN></FONT></SPAN> </DIV>
<BLOCKQUOTE style="MARGIN-RIGHT: 0px">
<DIV><SPAN class=281384315-02052002><FONT color=#0000ff face=Arial
size=2><SPAN class=863074407-03052002></SPAN>RATS</FONT></SPAN></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=281384315-02052002>rat-no rat-name
ratlets</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=281384315-02052002>1 Big
MOMMA RAT 10</SPAN></FONT></DIV>
<DIV><SPAN class=281384315-02052002></SPAN><FONT color=#0000ff face=Arial
size=2> </FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=281384315-02052002>RATLETS (index for ratlet-no and
index for ratlet-status)</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=281384315-02052002>ratlet-no rat-no ratlet-name
ratlet-status Termination-reason</SPAN></FONT></DIV>
<DIV><SPAN class=281384315-02052002></SPAN><FONT color=#0000ff face=Arial
size=2> </FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=281384315-02052002>lots of ratlets... mostly Dead thus the status
index</SPAN></FONT></DIV>
<DIV><SPAN class=281384315-02052002></SPAN><FONT color=#0000ff face=Arial
size=2> </FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=281384315-02052002>333 1 Billy
Bob Alive</SPAN></FONT></DIV>
<DIV><SPAN class=281384315-02052002></SPAN><FONT color=#0000ff face=Arial
size=2> </FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=281384315-02052002>RATLET-RACES (index for
ratlet-no)</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=281384315-02052002>ratlet-no race-no win-lose income</SPAN></FONT></DIV>
<DIV> </DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=281384315-02052002>333 1523 L $0.00</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=281384315-02052002>333 1627 L $0.00</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=281384315-02052002>333 1655 L $0.00</SPAN></FONT></DIV></BLOCKQUOTE>
<DIV><SPAN class=281384315-02052002></SPAN> </DIV>
<DIV><SPAN class=281384315-02052002>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=281384315-02052002><SPAN class=281384315-02052002><SPAN
class=863074407-03052002></SPAN><FONT color=#0000ff face=Arial size=2>s<SPAN
class=863074407-03052002>cr3________________________________________________________________________</SPAN></FONT></SPAN></SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=281384315-02052002><SPAN class=281384315-02052002><FONT color=#0000ff
face=Arial size=2><SPAN
class=863074407-03052002></SPAN></FONT></SPAN></SPAN></FONT> </DIV>
<BLOCKQUOTE style="MARGIN-RIGHT: 0px">
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=281384315-02052002><SPAN class=281384315-02052002><FONT color=#0000ff
face=Arial size=2><SPAN
class=863074407-03052002></SPAN></FONT></SPAN>RATS</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=281384315-02052002>rat-no rat-name
ratlets</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=281384315-02052002>1 Big
MOMMA RAT 10</SPAN></FONT></DIV>
<DIV><SPAN class=281384315-02052002></SPAN><FONT color=#0000ff face=Arial
size=2> </FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=281384315-02052002>RATLETS (index for ratlet-no and
index for ratlet-status)</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=281384315-02052002>ratlet-no rat-no ratlet-name
ratlet-status Termination-reason</SPAN></FONT></DIV>
<DIV><SPAN class=281384315-02052002></SPAN><FONT color=#0000ff face=Arial
size=2> </FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=281384315-02052002>lots of ratlets... mostly Dead thus the status
index</SPAN></FONT></DIV>
<DIV><SPAN class=281384315-02052002></SPAN><FONT color=#0000ff face=Arial
size=2> </FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=281384315-02052002>305
1
Benjamin Alive</SPAN></FONT></DIV>
<DIV><SPAN class=281384315-02052002></SPAN><FONT color=#0000ff face=Arial
size=2> </FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=281384315-02052002>RATLET-RACES (index for
ratlet-no)</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=281384315-02052002>ratlet-no race-no win-lose income</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=281384315-02052002>305 1234 W $100.00</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=281384315-02052002>305 1355 W $50.00</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=281384315-02052002>305 1425 L $0.00</SPAN></FONT></DIV></BLOCKQUOTE>
<DIV><SPAN
class=281384315-02052002></SPAN> </DIV></SPAN></SPAN></DIV></DIV></DIV></SPAN></DIV>
<P> </P>
<BLOCKQUOTE style="MARGIN-RIGHT: 0px">
<DIV align=left class=OutlookMessageHeader dir=ltr><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B> Daniel Mielke
[mailto:DMielke@aic.com]<BR><B>Sent:</B> 02 May 2002 17:28<BR><B>To:</B>
'Boyle, Joe'<BR><B>Cc:</B> Powerhouse List (E-mail)<BR><B>Subject:</B> RE:
QDESIGN file types and cluster control (PH607F on
AS/400)<BR><BR></DIV></FONT>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN class=281384315-02052002>Hi
Joe,</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=281384315-02052002></SPAN></FONT> </DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=281384315-02052002>The HOLD FIND statement applies to the PRIMARY file
if no DETAIL file exists and causes QUICK to "read into" the PRIMARY/DETAIL
files. In this case a DETAIL file exists and the access is
"sequential" using the specific index. If the PRIMARY file does not
supply the indexed field in the DETAIL file in the sequence of
the DETAIL file, QUICK does not reset its search to start from the
beginning of the DETAIL file. In the example, the screen would display
RATLETS 321 and 333 and stop. Scrolling back would retrieve 305.
I'm looking for all three. Thoughts?</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=281384315-02052002></SPAN></FONT> </DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=281384315-02052002>RATS</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=281384315-02052002>rat-no rat-name
ratlets</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=281384315-02052002>1 Big
MOMMA RAT 10</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=281384315-02052002></SPAN></FONT> </DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=281384315-02052002>RATLETS (index for ratlet-no and
index for ratlet-status)</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=281384315-02052002>ratlet-no rat-no ratlet-name
ratlet-status Termination-reason</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=281384315-02052002></SPAN></FONT> </DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=281384315-02052002>lots of ratlets... mostly Dead thus the status
index</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=281384315-02052002></SPAN></FONT> </DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=281384315-02052002>321 1 Bobby Ray
Alive</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=281384315-02052002>333 1 Billy
Bob Alive</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=281384315-02052002>305
1
Benjamin Alive</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=281384315-02052002></SPAN></FONT> </DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=281384315-02052002>RATLET-RACES (index for
ratlet-no)</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=281384315-02052002>ratlet-no race-no win-lose income</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=281384315-02052002>305 1234 W $100.00</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=281384315-02052002>305 1355 W $50.00</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=281384315-02052002>305 1425 L $0.00</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=281384315-02052002>321 1244 W $75.00</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=281384315-02052002>321 1255 W $45.00</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=281384315-02052002>333 1523 L $0.00</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=281384315-02052002>333 1627 L $0.00</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=281384315-02052002>333 1655 L $0.00</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=281384315-02052002>
</SPAN></FONT></DIV>
<BLOCKQUOTE style="MARGIN-RIGHT: 0px">
<DIV align=left class=OutlookMessageHeader dir=ltr><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B> Boyle, Joe
[mailto:Joe.Boyle@cognos.com]<BR><B>Sent:</B> Thursday, May 02, 2002 4:57
AM<BR><B>To:</B> 'Daniel Mielke'; Powerhouse List
(E-mail)<BR><B>Subject:</B> RE: QDESIGN file types and cluster control
(PH607F on AS/400)<BR><BR></DIV></FONT>
<P><FONT size=2>Hi Daniel,</FONT> </P>
<P><FONT size=2>how about something like that below, on receiving a rat
the user can scroll through ratlets ( by pressing return ), listing the
ratrace details for each ratlet,</FONT></P><BR>
<P><FONT size=2>can cle</FONT> </P>
<P><FONT size=2>SCREEN Screen4 RECEIVING RATS </FONT></P>
<P><FONT size=2>FILE RATS IN mydbst MASTER </FONT></P>
<P><FONT size=2>FILE RATLETS IN mydbst PRIMARY </FONT></P>
<P><FONT size=2>ACCESS USING order_no of RATS VIA order_no
</FONT></P>
<P><FONT size=2>FILE RAT_RACES IN mydbst detail OCCURS 10 </FONT></P>
<P><FONT size=2>Item
ORDER_NO_C
final ascii( ORDER_NO OF RATS ,10)</FONT> <BR><FONT
size=2>Item ORDER_LINE_NO_C
final ascii( ORDER_LINE_NO OF RAT_RACES ,4)</FONT> </P>
<P><FONT size=2>ACCESS USING order_no of RATLETS VIA
order_no </FONT></P>
<P><FONT size=2>FIELD ORDER_NO OF RATS
DISPLAY PREDISPLAY </FONT></P>
<P><FONT size=2>FIELD ORDER_LINE_NO OF RATLETS
DISPLAY PREDISPLAY </FONT></P>
<P><FONT size=2>align ( 1,,4 ) ( ,,20 ) ( ,,50 )</FONT> </P>
<P><FONT size=2>CLUSTER OCCURS WITH RAT_RACES</FONT> </P>
<P><FONT size=2>FIELD ORDER_LINE_NO OF RAT_RACES REQUIRED
NOCHANGE
&</FONT> <BR><FONT size=2> LOOKUP NOTON RAT_RACESVIA
ORDER_NO, ORDER_LINE_NO USING & </FONT><BR><FONT
size=2> ORDER_NO OF RATS, ORDER_LINE_NO OF
RAT_RACES</FONT> </P>
<P><FONT size=2>FIELD ORDER_LN_NAME OF RAT_RACES
</FONT></P>
<P><FONT size=2>FIELD ORDER_LN_BRANCH OF RAT_RACES
</FONT></P>
<P><FONT size=2>CLUSTER</FONT> </P>
<P><FONT size=2>BUILD LIST</FONT> </P><BR>
<P><FONT size=2>regards,</FONT> <BR><FONT size=2>Joe Boyle.</FONT>
</P><BR><BR>
<P><FONT size=2>-----Original Message-----</FONT> <BR><FONT size=2>From:
Daniel Mielke [<A
href="mailto:DMielke@aic.com">mailto:DMielke@aic.com</A>]</FONT> <BR><FONT
size=2>Sent: 01 May 2002 18:58</FONT> <BR><FONT size=2>To: Powerhouse List
(E-mail)</FONT> <BR><FONT size=2>Subject: QDESIGN file types and cluster
control (PH607F on AS/400)</FONT> </P><BR>
<P><FONT size=2>Hi Listers,</FONT> </P>
<P><FONT size=2>I'm getting some weird results when building a FIND only
screen.</FONT> </P>
<P><FONT size=2>Bear with me on this example(Once again, thanks
Chuck!):</FONT> </P>
<P><FONT size=2>I want to list the detail of RATLET-RACES for active
RATLETS. The user is</FONT> <BR><FONT size=2>coming into the screen
with a RAT record as MASTER. RATLETS is being</FONT> <BR><FONT
size=2>retrieved via ratlet-status and selected if rat-no of RAT = rat-no
of</FONT> <BR><FONT size=2>RATLETS. RATLET-RACES is a DETAIL file
indexed by ratlet-no (matching up to</FONT> <BR><FONT
size=2>RATLET). The cluster is based on the occurrence of
RATLET-RACES.</FONT> </P>
<P><FONT size=2>There are three active RATLETS. Each RATLETS record
has matching</FONT> <BR><FONT size=2>RATLET-RACES records. However
the screen displays only two RATLETS and</FONT> <BR><FONT
size=2>stops. The scrolling back doesn't work. When the HOLD
FIND is removed, the</FONT> <BR><FONT size=2>scrolling back works and gets
the third RATLETS record and associated</FONT> <BR><FONT
size=2>RATLET-RACES records. </FONT></P>
<P><FONT size=2>The impression that I get is that QUICK is passing once
though RATLET-RACES.</FONT> <BR><FONT size=2>QUICK finds RATLET-RACES for
the first RATLETS record, continuing on from</FONT> <BR><FONT size=2>that
point to get records for the second RATLETS record, and stopping
when</FONT> <BR><FONT size=2>it can't find RATLET-RACES records for third.
(RATLETS is not being</FONT> <BR><FONT size=2>retrieved in ratlet-no
order)</FONT> </P>
<P><FONT size=2>Is there a way to ?Reset? the access of the detail file
for each occurrence</FONT> <BR><FONT size=2>of RATLETS?</FONT> </P>
<P><FONT size=2>Should I change the file structure?</FONT> </P>
<P><FONT size=2>Help! </FONT></P>
<P><FONT size=2>> BUY. HOLD. AND PROSPER.</FONT> <BR><FONT size=2>>
</FONT><BR><FONT size=2>> Daniel Mielke</FONT> <BR><FONT size=2>>
Business Systems Analyst</FONT> <BR><FONT size=2>> AIC Limited</FONT>
<BR><FONT size=2>> 1-888-710-4242 (4614)</FONT> <BR><FONT size=2>>
dmielke@aic.com</FONT> <BR><FONT size=2>> www.aic.com</FONT> <BR><FONT
size=2>> </FONT><BR><FONT size=2>> </FONT></P>
<P><FONT size=2>= = = = = = = = = = = = = = = = = = = = = = = = = = =
=</FONT> <BR><FONT size=2>Mailing list: powerh-l@lists.swau.edu</FONT>
<BR><FONT size=2>Subscribe: "subscribe" in message body to
powerh-l-request@lists.swau.edu</FONT> <BR><FONT size=2>Unsubscribe:
"unsubscribe" in message body to powerh-l-request@lists.swau.edu</FONT>
<BR><FONT size=2><A href="http://lists.swau.edu/mailman/listinfo/powerh-l"
target=_blank>http://lists.swau.edu/mailman/listinfo/powerh-l</A></FONT>
<BR><FONT size=2>This list is closed, thus to post to the list you must be
a subscriber.</FONT> </P>
<P><FONT size=2>This message may contain privileged and/or confidential
information. If you have received this e-mail in error or are not
the intended recipient, you may not use, copy, disseminate or distribute
it; do not open any attachments, delete it immediately from your system
and notify the sender promptly by e-mail that you have done so.
Thank you.</FONT></P></BLOCKQUOTE></BLOCKQUOTE><BR>
<P><FONT face=Arial size=2>This message may contain privileged and/or
confidential information. If you have received this e-mail in error or are not
the intended recipient, you may not use, copy, disseminate or distribute it;
do not open any attachments, delete it immediately from your system and notify
the sender promptly by e-mail that you have done so. Thank
you.</FONT></P></BLOCKQUOTE></BODY></HTML>
------_=_NextPart_001_01C1F2D5.25415900--