QTP 6.07F on AS/400 sort sequence
Cousins, Michael
Michael.Cousins@Cognos.COM
Thu, 24 Apr 2003 16:15:46 -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_01C30A9E.4A599040
Content-Type: text/plain;
charset="iso-8859-1"
Quiz/Qtp isn't sorting the data retrieved via an index read - that is the
file system. Quiz/Qtp only sorts when there is a SORT statement in the code.
The EBCDIC table (for an IBM based o/s) lists number characters after letter
characters as opposed to the ASCII table which lists numbers first. It is
the character's position in the code page table that determines the sort
sequence.
You may want to try defining the index in pdl.
Index RAT-IDX [index options... ]
SEGMENT rat-no [datatype...]
SEGMENT ratlet-name [datatype...] DESCENDING
This will affect all programs reading this file via this index.
-----Original Message-----
From: Daniel Mielke [mailto:DMielke@aic.com]
Sent: Thursday, April 24, 2003 3:40 PM
To: 'David Morrison - Corporate'; Powerhouse List (E-mail)
Subject: RE: QTP 6.07F on AS/400 sort sequence
Thanks David,
Get this..
RAT-DATA is loaded by QTP sorting on rat-no, ratlet-name. Temporary item
t-rat-group ascends at rat-name during QTP to provide value to rat-group.
RAT-DATA
rat-no ratlet-name rat-group other-rat-data
000001 2pac 1
000001 Alice 2
000001 Alice 2
000001 Pet2nia 3
000001 Pet2nia 3
000001 Petunia 4
000001 Petunia 4
RAT-IDX index is keyed by rat-no, ratlet-name. Logical file(as400) is
SRTSEQ(*HEX)
First record that quiz pulls using "choose viaindex RAT-IDX rat-no 000001"
is Alice and not the expected 2pac.
Any comments? Ideas as to where "code page" is located for AS400 version
(as per Michael's comment attached)?
-----Original Message-----
From: Cousins, Michael [mailto:Michael.Cousins@Cognos.COM]
Sent: Thursday, April 24, 2003 2:44 PM
To: 'Daniel Mielke'
Subject: RE: QTP 6.07F on AS/400 sort sequence
You're on an IBM system therefore an EBCDIC code page not ASCII.
One is reverse to the other in terms of which comes first, numbers or
letters.
PH sorting is governed by the code page of the o/s on which it is run.
-----Original Message-----
From: David Morrison - Corporate [mailto:dmorrison@mcbrideelectric.com]
Sent: Thursday, April 24, 2003 3:13 PM
To: Daniel Mielke; Powerhouse List (E-mail)
Subject: RE: QTP 6.07F on AS/400 sort sequence
Daniel,
It uses the EBCDIC sort sequence. Letters before numbers. You may be able
to change this, in your data dictionary, but I'd recommend against it. If
you have a particular need in one program to sort differently, I'd create a
temporary field and sort on that field, instead.
David Morrison
McBride Electric
-----Original Message-----
From: Daniel Mielke [mailto:DMielke@aic.com]
Sent: Thursday, April 24, 2003 11:33 AM
To: Powerhouse List (E-mail)
Subject: QTP 6.07F on AS/400 sort sequence
Hi all,
Is the sort sequence for PH fixed or system determined?
I have an alphanumeric field that contains A-Z as well as 0-9. So for
example, I have three records as below, what would the PH sort order be for
"sort on alpha-data-field"?
alpha-data-field
AJONES
aJONES
1JONES
> 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 <password>" 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.
_________________________________________________
Scanned for viruses on 24 Apr 2003 18:43:19
No viruses found.
Virus scanning by http://erado.com
= = = = = = = = = = = = = = = = = = = = = = = = = = = =
Mailing list: powerh-l@lists.swau.edu
Subscribe: "subscribe" in message body to powerh-l-request@lists.swau.edu
Unsubscribe: "unsubscribe <password>" 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_01C30A9E.4A599040
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
5.5.2654.89">
<TITLE>RE: QTP 6.07F on AS/400 sort sequence</TITLE>
</HEAD>
<BODY>
<BR>
<P><FONT SIZE=3D2>Quiz/Qtp isn't sorting the data retrieved via an =
index read - that is the file system. Quiz/Qtp only sorts when there is =
a SORT statement in the code. The EBCDIC table (for an IBM based o/s) =
lists number characters after letter characters as opposed to the ASCII =
table which lists numbers first. It is the character's position in the =
code page table that determines the sort sequence.</FONT></P>
<P><FONT SIZE=3D2>You may want to try defining the index in pdl.</FONT>
</P>
<P><FONT SIZE=3D2>Index RAT-IDX [index options... ]</FONT>
<BR><FONT SIZE=3D2> SEGMENT rat-no [datatype...]</FONT>
<BR><FONT SIZE=3D2> SEGMENT ratlet-name [datatype...] =
DESCENDING</FONT>
</P>
<P><FONT SIZE=3D2>This will affect all programs reading this file via =
this index.</FONT>
</P>
<P><FONT SIZE=3D2>-----Original Message-----</FONT>
<BR><FONT SIZE=3D2>From: Daniel Mielke [<A =
HREF=3D"mailto:DMielke@aic.com">mailto:DMielke@aic.com</A>]</FONT>
<BR><FONT SIZE=3D2>Sent: Thursday, April 24, 2003 3:40 PM</FONT>
<BR><FONT SIZE=3D2>To: 'David Morrison - Corporate'; Powerhouse List =
(E-mail)</FONT>
<BR><FONT SIZE=3D2>Subject: RE: QTP 6.07F on AS/400 sort =
sequence</FONT>
</P>
<BR>
<P><FONT SIZE=3D2>Thanks David,</FONT>
</P>
<P><FONT SIZE=3D2>Get this..</FONT>
</P>
<P><FONT SIZE=3D2>RAT-DATA is loaded by QTP sorting on rat-no, =
ratlet-name. Temporary item</FONT>
<BR><FONT SIZE=3D2>t-rat-group ascends at rat-name during QTP to =
provide value to rat-group.</FONT>
</P>
<P><FONT SIZE=3D2>RAT-DATA</FONT>
<BR><FONT SIZE=3D2>rat-no ratlet-name rat-group other-rat-data</FONT>
<BR><FONT SIZE=3D2>000001 =
2pac 1</FONT>
<BR><FONT SIZE=3D2>000001 Alice =
2</FONT>
<BR><FONT SIZE=3D2>000001 Alice =
2</FONT>
<BR><FONT SIZE=3D2>000001 Pet2nia =
3 </FONT>
<BR><FONT SIZE=3D2>000001 Pet2nia 3</FONT>
<BR><FONT SIZE=3D2>000001 Petunia 4</FONT>
<BR><FONT SIZE=3D2>000001 Petunia 4</FONT>
</P>
<P><FONT SIZE=3D2>RAT-IDX index is keyed by rat-no, ratlet-name. =
Logical file(as400) is</FONT>
<BR><FONT SIZE=3D2>SRTSEQ(*HEX)</FONT>
</P>
<P><FONT SIZE=3D2>First record that quiz pulls using "choose =
viaindex RAT-IDX rat-no 000001"</FONT>
<BR><FONT SIZE=3D2>is Alice and not the expected 2pac.</FONT>
</P>
<P><FONT SIZE=3D2>Any comments? Ideas as to where "code =
page" is located for AS400 version</FONT>
<BR><FONT SIZE=3D2>(as per Michael's comment attached)?</FONT>
</P>
<BR>
<BR>
<P><FONT SIZE=3D2>-----Original Message-----</FONT>
<BR><FONT SIZE=3D2>From: Cousins, Michael [<A =
HREF=3D"mailto:Michael.Cousins@Cognos.COM">mailto:Michael.Cousins@Cognos=
.COM</A>]</FONT>
<BR><FONT SIZE=3D2>Sent: Thursday, April 24, 2003 2:44 PM</FONT>
<BR><FONT SIZE=3D2>To: 'Daniel Mielke'</FONT>
<BR><FONT SIZE=3D2>Subject: RE: QTP 6.07F on AS/400 sort =
sequence</FONT>
</P>
<BR>
<P><FONT SIZE=3D2>You're on an IBM system therefore an EBCDIC code page =
not ASCII. </FONT>
<BR><FONT SIZE=3D2>One is reverse to the other in terms of which comes =
first, numbers or</FONT>
<BR><FONT SIZE=3D2>letters. </FONT>
<BR><FONT SIZE=3D2>PH sorting is governed by the code page of the o/s =
on which it is run. </FONT>
</P>
<BR>
<P><FONT SIZE=3D2>-----Original Message-----</FONT>
<BR><FONT SIZE=3D2>From: David Morrison - Corporate [<A =
HREF=3D"mailto:dmorrison@mcbrideelectric.com">mailto:dmorrison@mcbrideel=
ectric.com</A>]</FONT>
<BR><FONT SIZE=3D2>Sent: Thursday, April 24, 2003 3:13 PM</FONT>
<BR><FONT SIZE=3D2>To: Daniel Mielke; Powerhouse List (E-mail)</FONT>
<BR><FONT SIZE=3D2>Subject: RE: QTP 6.07F on AS/400 sort =
sequence</FONT>
</P>
<BR>
<P><FONT SIZE=3D2>Daniel,</FONT>
</P>
<P><FONT SIZE=3D2>It uses the EBCDIC sort sequence. Letters =
before numbers. You may be able</FONT>
<BR><FONT SIZE=3D2>to change this, in your data dictionary, but I'd =
recommend against it. If</FONT>
<BR><FONT SIZE=3D2>you have a particular need in one program to sort =
differently, I'd create a</FONT>
<BR><FONT SIZE=3D2>temporary field and sort on that field, =
instead.</FONT>
</P>
<P><FONT SIZE=3D2>David Morrison</FONT>
<BR><FONT SIZE=3D2>McBride Electric</FONT>
</P>
<P><FONT SIZE=3D2> -----Original Message-----</FONT>
<BR><FONT SIZE=3D2>From: Daniel Mielke [<A =
HREF=3D"mailto:DMielke@aic.com">mailto:DMielke@aic.com</A>] </FONT>
<BR><FONT SIZE=3D2>Sent: Thursday, April 24, 2003 11:33 =
AM</FONT>
<BR><FONT SIZE=3D2>To: Powerhouse List =
(E-mail)</FONT>
<BR><FONT SIZE=3D2>Subject: =
QTP 6.07F on AS/400 sort sequence</FONT>
</P>
<P><FONT SIZE=3D2>Hi all,</FONT>
</P>
<P><FONT SIZE=3D2>Is the sort sequence for PH fixed or system =
determined?</FONT>
</P>
<P><FONT SIZE=3D2>I have an alphanumeric field that contains A-Z as =
well as 0-9. So for</FONT>
<BR><FONT SIZE=3D2>example, I have three records as below, what would =
the PH sort order be for</FONT>
<BR><FONT SIZE=3D2>"sort on alpha-data-field"?</FONT>
</P>
<P><FONT SIZE=3D2>alpha-data-field</FONT>
<BR><FONT SIZE=3D2>AJONES</FONT>
<BR><FONT SIZE=3D2>aJONES</FONT>
<BR><FONT SIZE=3D2>1JONES</FONT>
</P>
<BR>
<P><FONT SIZE=3D2>> BUY. HOLD. AND PROSPER.</FONT>
<BR><FONT SIZE=3D2>> </FONT>
<BR><FONT SIZE=3D2>> Daniel Mielke</FONT>
<BR><FONT SIZE=3D2>> Business Systems Analyst</FONT>
<BR><FONT SIZE=3D2>> AIC Limited</FONT>
<BR><FONT SIZE=3D2>> 1-888-710-4242 (4614)</FONT>
<BR><FONT SIZE=3D2>> dmielke@aic.com</FONT>
<BR><FONT SIZE=3D2>> www.aic.com</FONT>
<BR><FONT SIZE=3D2>> </FONT>
<BR><FONT SIZE=3D2>> </FONT>
<BR><FONT SIZE=3D2>=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</FONT>
<BR><FONT SIZE=3D2>Mailing list: powerh-l@lists.swau.edu</FONT>
<BR><FONT SIZE=3D2>Subscribe: "subscribe" in message body to =
powerh-l-request@lists.swau.edu</FONT>
<BR><FONT SIZE=3D2>Unsubscribe: "unsubscribe =
<password>" in message body to</FONT>
<BR><FONT SIZE=3D2>powerh-l-request@lists.swau.edu</FONT>
<BR><FONT SIZE=3D2><A =
HREF=3D"http://lists.swau.edu/mailman/listinfo/powerh-l" =
TARGET=3D"_blank">http://lists.swau.edu/mailman/listinfo/powerh-l</A></F=
ONT>
<BR><FONT SIZE=3D2>This list is closed, thus to post to the list you =
must be a subscriber.</FONT>
</P>
<BR>
<P><FONT =
SIZE=3D2>_________________________________________________</FONT>
<BR><FONT SIZE=3D2>Scanned for viruses on 24 Apr 2003 18:43:19</FONT>
<BR><FONT SIZE=3D2>No viruses found.</FONT>
<BR><FONT SIZE=3D2>Virus scanning by <A HREF=3D"http://erado.com" =
TARGET=3D"_blank">http://erado.com</A></FONT>
</P>
<P><FONT SIZE=3D2>=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</FONT>
<BR><FONT SIZE=3D2>Mailing list: powerh-l@lists.swau.edu</FONT>
<BR><FONT SIZE=3D2>Subscribe: "subscribe" in message body to =
powerh-l-request@lists.swau.edu</FONT>
<BR><FONT SIZE=3D2>Unsubscribe: "unsubscribe =
<password>" in message body to =
powerh-l-request@lists.swau.edu</FONT>
<BR><FONT SIZE=3D2><A =
HREF=3D"http://lists.swau.edu/mailman/listinfo/powerh-l" =
TARGET=3D"_blank">http://lists.swau.edu/mailman/listinfo/powerh-l</A></F=
ONT>
<BR><FONT SIZE=3D2>This list is closed, thus to post to the list you =
must be a subscriber.</FONT>
</P>
<P><FONT SIZE=3D2>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>
</BODY>
</HTML>
------_=_NextPart_001_01C30A9E.4A599040--