QDESIGN file types and cluster control (PH607F on AS/400)

Thu, 2 May 2002 12:28:18 -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_01C1F1F6.5DD14850
Content-Type: text/plain;
	charset="iso-8859-1"

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.

------_=_NextPart_001_01C1F1F6.5DD14850
Content-Type: text/html;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">
<TITLE>RE: QDESIGN file types and cluster control (PH607F on =
AS/400)</TITLE>

<META content=3D"MSHTML 5.00.2919.6307" name=3DGENERATOR></HEAD>
<BODY>
<DIV>Hi=20
Joe,</DIV>
<DIV><SPAN=20
class=3D281384315-02052002>&nbsp;</DIV>
<DIV>The=20
HOLD FIND statement applies to the PRIMARY file if no DETAIL file =
exists and=20
causes QUICK to "read into" the PRIMARY/DETAIL files.&nbsp; In this =
case a=20
DETAIL file exists and the access is "sequential" using the specific=20
index.&nbsp; If the PRIMARY file does not supply the indexed field in =
the DETAIL=20
file in the sequence of the&nbsp;DETAIL file,&nbsp;QUICK does not reset =
its=20
search to start from the beginning of the DETAIL file.&nbsp; In the =
example, the=20
screen would display RATLETS 321 and 333 and stop.&nbsp; Scrolling back =
would=20
retrieve 305.&nbsp; I'm looking for all three.&nbsp;=20
Thoughts?</DIV>
<DIV><SPAN=20
class=3D281384315-02052002>&nbsp;</DIV>
<DIV><SPAN=20
class=3D281384315-02052002>RATS</DIV>
<DIV><SPAN=20
class=3D281384315-02052002>rat-no&nbsp;&nbsp;&nbsp; =
rat-name&nbsp;&nbsp;&nbsp;=20
ratlets</DIV>
<DIV><SPAN=20
class=3D281384315-02052002>1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n=
bsp;Big=20
MOMMA RAT&nbsp;&nbsp;&nbsp;&nbsp;10</DIV>
<DIV><SPAN=20
class=3D281384315-02052002>&nbsp;</DIV>
<DIV><SPAN=20
class=3D281384315-02052002>RATLETS&nbsp;&nbsp;&nbsp; (index for =
ratlet-no and=20
index for ratlet-status)</DIV>
<DIV><SPAN=20
class=3D281384315-02052002>ratlet-no&nbsp;&nbsp;&nbsp;&nbsp;rat-no&nbsp;=
&nbsp;&nbsp;&nbsp;ratlet-name=20
ratlet-status&nbsp;&nbsp;&nbsp; Termination-reason</DIV>
<DIV><SPAN=20
class=3D281384315-02052002>&nbsp;</DIV>
<DIV>lots=20
of ratlets... mostly Dead thus the status index</DIV>
<DIV><SPAN=20
class=3D281384315-02052002>&nbsp;</DIV>
<DIV><SPAN=20
class=3D281384315-02052002>321&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Bobby&nbsp;Ray&nb=
sp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
Alive</DIV>
<DIV><SPAN=20
class=3D281384315-02052002>333&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Billy=20
Bob&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Ali=
ve</DIV>
<DIV><SPAN=20
class=3D281384315-02052002>305&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
=20
1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
Benjamin&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
Alive</DIV>
<DIV><SPAN=20
class=3D281384315-02052002>&nbsp;</DIV>
<DIV><SPAN=20
class=3D281384315-02052002>RATLET-RACES&nbsp; (index for=20
ratlet-no)</DIV>
<DIV><SPAN=20
class=3D281384315-02052002>ratlet-no&nbsp;&nbsp;&nbsp;&nbsp;race-no&nbsp=
;&nbsp;&nbsp;&nbsp;win-lose&nbsp;&nbsp;&nbsp;&nbsp;income<=
/DIV>
<DIV><SPAN=20
class=3D281384315-02052002>305&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;1234&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;W&nbsp;&nbsp;&=
nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$100.00</DIV>
<DIV><SPAN=20
class=3D281384315-02052002>305&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;1355&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;W&nbsp;&nbsp;&=
nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$50.00</DIV>
<DIV><SPAN=20
class=3D281384315-02052002>305&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;1425&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;L&nbsp;&nbsp;&=
nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$0.00</DIV>
<DIV><SPAN=20
class=3D281384315-02052002>321&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;1244&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;W&nbsp;&nbsp;&=
nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$75.00</DIV>
<DIV><SPAN=20
class=3D281384315-02052002>321&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;1255&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;W&nbsp;&nbsp;&=
nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$45.00</DIV>
<DIV><SPAN=20
class=3D281384315-02052002>333&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;1523&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;L&nbsp;&nbsp;&=
nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$0.00</DIV>
<DIV><SPAN=20
class=3D281384315-02052002>333&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;1627&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;L&nbsp;&nbsp;&=
nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$0.00</DIV>
<DIV><SPAN=20
class=3D281384315-02052002>333&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;1655&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;L&nbsp;&nbsp;&=
nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$0.00</DIV>
<DIV><SPAN=20
class=3D281384315-02052002>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb=
sp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
</DIV>
<BLOCKQUOTE style=3D"MARGIN-RIGHT: 0px">
 <DIV align=3Dleft class=3DOutlookMessageHeader dir=3Dltr>-----Original Message----- From: Boyle, Joe=20
 [mailto:Joe.Boyle@cognos.com] Sent: Thursday, May 02, 2002 =
4:57=20
 AM To: 'Daniel Mielke'; Powerhouse List =
(E-mail) Subject:=20
 RE: QDESIGN file types and cluster control (PH607F on=20
 AS/400) </DIV>
 Hi Daniel, 
 how about something like that below, on receiving a =
rat the=20
 user can scroll through ratlets ( by pressing return ), listing the =
ratrace=20
 details for each ratlet, 
 can cle 
 SCREEN Screen4&nbsp;&nbsp; RECEIVING RATS =

 FILE RATS IN mydbst MASTER 
 FILE RATLETS IN mydbst&nbsp; PRIMARY 
 ACCESS&nbsp; USING order_no of RATS VIA =
order_no&nbsp;=20
 
 FILE RAT_RACES IN mydbst detail OCCURS 10 =

 Item=20
 =
ORDER_NO_C&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n=
bsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
 final ascii( ORDER_NO OF RATS&nbsp;&nbsp;&nbsp; ,10) <FONT =

size=3D2>Item =
ORDER_LINE_NO_C&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; final=20
 ascii( ORDER_LINE_NO OF RAT_RACES&nbsp;&nbsp; ,4) 
 ACCESS&nbsp; USING order_no of RATLETS&nbsp; VIA=20
 order_no&nbsp; 
 FIELD ORDER_NO OF RATS&nbsp;&nbsp;&nbsp; =
DISPLAY&nbsp;&nbsp;=20
 PREDISPLAY&nbsp;&nbsp; 
 FIELD ORDER_LINE_NO OF RATLETS&nbsp;&nbsp;&nbsp;=20
 DISPLAY&nbsp;&nbsp; PREDISPLAY&nbsp;&nbsp; 
 align ( 1,,4 )&nbsp; ( ,,20 ) ( ,,50 ) 
 CLUSTER&nbsp; OCCURS WITH RAT_RACES 
 FIELD ORDER_LINE_NO OF RAT_RACES REQUIRED=20
 =
NOCHANGE&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbs=
p;&nbsp;&nbsp;&nbsp;&nbsp;=20
 &amp; &nbsp;&nbsp;&nbsp; LOOKUP NOTON =
RAT_RACESVIA=20
 ORDER_NO, ORDER_LINE_NO USING&nbsp; &amp; <FONT=20
 size=3D2>&nbsp;&nbsp;&nbsp; ORDER_NO OF RATS, ORDER_LINE_NO OF =
RAT_RACES=20
 
 FIELD ORDER_LN_NAME OF =
RAT_RACES&nbsp;&nbsp;&nbsp;&nbsp;=20
 
 FIELD ORDER_LN_BRANCH OF =
RAT_RACES&nbsp;&nbsp;&nbsp;&nbsp;=20
 
 CLUSTER 
 BUILD LIST 
 regards, Joe =
Boyle.=20
 
 -----Original Message----- From:=20
 Daniel Mielke [<A=20
 href=3D"mailto:DMielke@aic.com">mailto:DMielke@aic.com</A>] =
 <FONT=20
 size=3D2>Sent: 01 May 2002 18:58 To: =
Powerhouse List=20
 (E-mail) Subject: QDESIGN file types and =
cluster=20
 control (PH607F on AS/400) 
 Hi Listers, 
 I'm getting some weird results when building a FIND =
only=20
 screen. 
 Bear with me on this example(Once again, thanks=20
 Chuck!): 
 I want to list the detail of RATLET-RACES for =
active=20
 RATLETS.&nbsp; The user is coming into the =
screen with=20
 a RAT record as MASTER.&nbsp; RATLETS is being <FONT=20
 size=3D2>retrieved via ratlet-status and selected if rat-no of RAT =
=3D rat-no=20
 of RATLETS.&nbsp; RATLET-RACES is a DETAIL =
file=20
 indexed by ratlet-no (matching up to RATLET).&nbsp;=20
 The cluster is based on the occurrence of RATLET-RACES. 
 There are three active RATLETS.&nbsp; Each RATLETS =
record has=20
 matching RATLET-RACES records.&nbsp; =
However the=20
 screen displays only two RATLETS and stops.&nbsp; The=20
 scrolling back doesn't work.&nbsp; When the HOLD FIND is removed, =
the=20
 scrolling back works and gets the third RATLETS =
record and=20
 associated RATLET-RACES records.&nbsp; =

 The impression that I get is that QUICK is passing =
once though=20
 RATLET-RACES. QUICK finds RATLET-RACES for =
the first=20
 RATLETS record, continuing on from that =
point to get=20
 records for the second RATLETS record, and stopping when =
 <FONT=20
 size=3D2>it can't find RATLET-RACES records for third. (RATLETS is =
not=20
 being retrieved in ratlet-no order) =

 Is there a way to ?Reset? the access of the detail =
file for=20
 each occurrence of RATLETS? 
 Should I change the file structure? 
 Help! 
 &gt; BUY. HOLD. AND PROSPER. &gt;=20
 &gt; Daniel Mielke &gt;=20
 Business Systems Analyst &gt; AIC =
Limited=20
 &gt; 1-888-710-4242 (4614) &gt;=20
 dmielke@aic.com &gt; www.aic.com =
 <FONT=20
 size=3D2>&gt; &gt; 
 =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =
=3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D=20
 Mailing list: powerh-l@lists.swau.edu =
 <FONT=20
 size=3D2>Subscribe: "subscribe" in message body to=20
 powerh-l-request@lists.swau.edu Unsubscribe:=20
 "unsubscribe" in message body to =
powerh-l-request@lists.swau.edu=20
 <A =
href=3D"http://lists.swau.edu/mailman/listinfo/powerh-l"=20
 =
target=3D_blank>http://lists.swau.edu/mailman/listinfo/powerh-l</A></FON=
T>=20
 This list is closed, thus to post to the list you =
must be a=20
 subscriber. 
 This message may contain privileged and/or =
confidential=20
 information.&nbsp; If you have received this e-mail in error or are =
not the=20
 intended recipient, you may not use, copy, disseminate or distribute =
it; do=20
 not open any attachments, delete it immediately from your system and =
notify=20
 the sender promptly by e-mail that you have done so.&nbsp; Thank=20
 you.</BLOCKQUOTE></BODY></HTML>

------_=_NextPart_001_01C1F1F6.5DD14850--