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_01C1F1B7.458A3840
Content-Type: text/plain;
charset="iso-8859-1"
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]
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
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_01C1F1B7.458A3840
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
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 &n=
bsp; 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 &nbs=
p; &
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]
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 =3D 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
>
>
=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
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
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_01C1F1B7.458A3840--