QTP 6.07F on AS/400 sort sequence

Thu, 24 Apr 2003 13:28:15 -0700

This is a multi-part message in MIME format.

------_=_NextPart_001_01C30AA0.0897D068
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Michael,
=20
I don't think that using DESCENDING will be sufficient.  I think Daniel =
wants digits before letters, but he wants 1 before 9 and A before Z.
=20
David Morrison
McBride Electric
=20
-----Original Message-----
From: Cousins, Michael [mailto:Michael.Cousins@Cognos.COM]
Sent: Thursday, April 24, 2003 1:16 PM
To: 'Daniel Mielke'; David Morrison - Corporate; Powerhouse List =
(E-mail)
Subject: RE: QTP 6.07F on AS/400 sort sequence
=20
=20
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.=20
Index RAT-IDX [index options... ]=20
 SEGMENT rat-no [datatype...]=20
 SEGMENT ratlet-name [datatype...] DESCENDING=20
This will affect all programs reading this file via this index.=20
-----Original Message-----=20
From: Daniel Mielke [ mailto:DMielke@aic.com]=20
Sent: Thursday, April 24, 2003 3:40 PM=20
To: 'David Morrison - Corporate'; Powerhouse List (E-mail)=20
Subject: RE: QTP 6.07F on AS/400 sort sequence=20
=20
Thanks David,=20
Get this..=20
RAT-DATA is loaded by QTP sorting on rat-no, ratlet-name.  Temporary =
item=20
t-rat-group ascends at rat-name during QTP to provide value to =
rat-group.=20
RAT-DATA=20
rat-no ratlet-name rat-group other-rat-data=20
000001 2pac        1=20
000001 Alice       2=20
000001 Alice       2=20
000001 Pet2nia     3        =20
000001 Pet2nia     3=20
000001 Petunia     4=20
000001 Petunia     4=20
RAT-IDX index is keyed by rat-no, ratlet-name.  Logical file(as400) is=20
SRTSEQ(*HEX)=20
First record that quiz pulls using "choose viaindex RAT-IDX rat-no =
000001"=20
is Alice and not the expected 2pac.=20
Any comments?  Ideas as to where "code page" is located for AS400 =
version=20
(as per Michael's comment attached)?=20
=20
-----Original Message-----=20
From: Cousins, Michael [ mailto:Michael.Cousins@Cognos.COM]=20
Sent: Thursday, April 24, 2003 2:44 PM=20
To: 'Daniel Mielke'=20
Subject: RE: QTP 6.07F on AS/400 sort sequence=20
=20
You're on an IBM system therefore an EBCDIC code page not ASCII.=20
One is reverse to the other in terms of which comes first, numbers or=20
letters.=20
PH sorting is governed by the code page of the o/s on which it is run.=20
=20
-----Original Message-----=20
From: David Morrison - Corporate [ mailto:dmorrison@mcbrideelectric.com] =

Sent: Thursday, April 24, 2003 3:13 PM=20
To: Daniel Mielke; Powerhouse List (E-mail)=20
Subject: RE: QTP 6.07F on AS/400 sort sequence=20
=20
Daniel,=20
It uses the EBCDIC sort sequence.  Letters before numbers.  You may be =
able=20
to change this, in your data dictionary, but I'd recommend against it.  =
If=20
you have a particular need in one program to sort differently, I'd =
create a=20
temporary field and sort on that field, instead.=20
David Morrison=20
McBride Electric=20
 -----Original Message-----=20
From:   Daniel Mielke [ mailto:DMielke@aic.com]=20
Sent:   Thursday, April 24, 2003 11:33 AM=20
To:     Powerhouse List (E-mail)=20
Subject:        QTP 6.07F on AS/400 sort sequence=20
Hi all,=20
Is the sort sequence for PH fixed or system determined?=20
I have an alphanumeric field that contains A-Z as well as 0-9.  So for=20
example, I have three records as below, what would the PH sort order be =
for=20
"sort on alpha-data-field"?=20
alpha-data-field=20
AJONES=20
aJONES=20
1JONES=20
=20
> BUY. HOLD. AND PROSPER.=20
>=20
> Daniel Mielke=20
> Business Systems Analyst=20
> AIC Limited=20
> 1-888-710-4242 (4614)=20
> dmielke@aic.com=20
> www.aic.com=20
>=20
>=20
=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=20
Subscribe: "subscribe" in message body to =
powerh-l-request@lists.swau.edu=20
Unsubscribe: "unsubscribe <password>" in message body to=20
powerh-l-request@lists.swau.edu=20
http://lists.swau.edu/mailman/listinfo/powerh-l=20
This list is closed, thus to post to the list you must be a subscriber.=20
=20
_________________________________________________=20
Scanned for viruses on 24 Apr 2003 18:43:19=20
No viruses found.=20
Virus scanning by http://erado.com=20
=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=20
Subscribe: "subscribe" in message body to =
powerh-l-request@lists.swau.edu=20
Unsubscribe: "unsubscribe <password>" in message body to =
powerh-l-request@lists.swau.edu=20
http://lists.swau.edu/mailman/listinfo/powerh-l=20
This list is closed, thus to post to the list you must be a subscriber.=20
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.

_________________________________________________=20
Scanned for viruses on 24 Apr 2003 20:20:01=20
No viruses found.=20
Virus scanning by http://erado.com

------_=_NextPart_001_01C30AA0.0897D068
Content-Type: text/html;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<html xmlns:o=3D"urn:schemas-microsoft-com:office:office" =
xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns=3D"http://www.w3.org/TR/REC-html40">

<head>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">

<meta name=3DProgId content=3DWord.Document>
<meta name=3DGenerator content=3D"Microsoft Word 9">
<meta name=3DOriginator content=3D"Microsoft Word 9">
<link rel=3DFile-List href=3D"cid:filelist.xml@01C30A65.55654260">
<title>RE: QTP 6.07F on AS/400 sort sequence</title>
<!--[if gte mso 9]><xml>
 <o:OfficeDocumentSettings>
  <o:DoNotRelyOnCSS/>
 </o:OfficeDocumentSettings>
</xml><![endif]--><!--[if gte mso 9]><xml>
 <w:WordDocument>
  <w:Zoom>0</w:Zoom>
  <w:DocumentKind>DocumentEmail</w:DocumentKind>
  <w:EnvelopeVis/>
 </w:WordDocument>
</xml><![endif]-->
<style>
<!--
 /* Font Definitions */
@font-face
	{font-family:Tahoma;
	panose-1:2 11 6 4 3 5 4 4 2 4;
	mso-font-charset:0;
	mso-generic-font-family:swiss;
	mso-font-pitch:variable;
	mso-font-signature:1627421319 -2147483648 8 0 66047 0;}
 /* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
	{mso-style-parent:"";
	margin:0in;
	margin-bottom:.0001pt;
	mso-pagination:widow-orphan;
	font-size:12.0pt;
	font-family:"Times New Roman";
	mso-fareast-font-family:"Times New Roman";}
a:link, span.MsoHyperlink
	{color:blue;
	text-decoration:underline;
	text-underline:single;}
a:visited, span.MsoHyperlinkFollowed
	{color:blue;
	text-decoration:underline;
	text-underline:single;}
p.MsoAutoSig, li.MsoAutoSig, div.MsoAutoSig
	{margin:0in;
	margin-bottom:.0001pt;
	mso-pagination:widow-orphan;
	font-size:12.0pt;
	font-family:"Times New Roman";
	mso-fareast-font-family:"Times New Roman";}
p
	{margin-right:0in;
	mso-margin-top-alt:auto;
	mso-margin-bottom-alt:auto;
	margin-left:0in;
	mso-pagination:widow-orphan;
	font-size:12.0pt;
	font-family:"Times New Roman";
	mso-fareast-font-family:"Times New Roman";}
span.EmailStyle18
	{mso-style-type:personal-reply;
	mso-ansi-font-size:10.0pt;
	mso-ascii-font-family:Arial;
	mso-hansi-font-family:Arial;
	mso-bidi-font-family:Arial;
	color:navy;}
@page Section1
	{size:8.5in 11.0in;
	margin:1.0in 1.25in 1.0in 1.25in;
	mso-header-margin:.5in;
	mso-footer-margin:.5in;
	mso-paper-source:0;}
div.Section1
	{page:Section1;}
-->
</style>
</head>

<body lang=3DEN-US link=3Dblue vlink=3Dblue style=3D'tab-interval:.5in'>

<div class=3DSection1>

<p class=3DMsoNormal><span class=3DEmailStyle18><font size=3D2 =
color=3Dnavy face=3DArial><span
style=3D'font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial'>Mi=
chael,<o:p></o:p></span></font></span></p>

<p class=3DMsoNormal><span class=3DEmailStyle18><font size=3D2 =
color=3Dnavy face=3DArial><span
style=3D'font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial'><!=
[if =
!supportEmptyParas]>&nbsp;<![endif]><o:p></o:p></span></font></span></p>

<p class=3DMsoNormal><span class=3DEmailStyle18><font size=3D2 =
color=3Dnavy face=3DArial><span
style=3D'font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial'>I =
don&#8217;t
think that using DESCENDING will be sufficient.<span =
style=3D"mso-spacerun:
yes">&nbsp; </span>I think Daniel wants digits before letters, but he =
wants 1
before 9 and A before Z.<o:p></o:p></span></font></span></p>

<p class=3DMsoNormal><span class=3DEmailStyle18><font size=3D2 =
color=3Dnavy face=3DArial><span
style=3D'font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial'><!=
[if =
!supportEmptyParas]>&nbsp;<![endif]><o:p></o:p></span></font></span></p>

<p class=3DMsoAutoSig><!--[if supportFields]><span =
class=3DEmailStyle18><font=20
size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:10.0pt;mso-bidi-font-size:
12.0pt;font-family:Arial'><span =
style=3D'mso-element:field-begin'></span><span=20
style=3D"mso-spacerun: yes">&nbsp;</span>AUTOTEXTLIST \s &quot;E-mail=20
Signature&quot; <span =
style=3D'mso-element:field-separator'></span></span></font></span><![endi=
f]--><font
color=3Dnavy><span style=3D'color:navy'>David =
Morrison</span></font><font
color=3Dnavy><span =
style=3D'color:navy;mso-color-alt:windowtext'><o:p></o:p></span></font></=
p>

<p class=3DMsoAutoSig><font size=3D3 color=3Dnavy face=3D"Times New =
Roman"><span
style=3D'font-size:12.0pt;color:navy'>McBride =
Electric</span></font><font
color=3Dnavy><span =
style=3D'color:navy;mso-color-alt:windowtext'><o:p></o:p></span></font></=
p>

<p class=3DMsoNormal><!--[if supportFields]><span =
class=3DEmailStyle18><font=20
size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:10.0pt;mso-bidi-font-size:
12.0pt;font-family:Arial'><span =
style=3D'mso-element:field-end'></span></span></font></span><![endif]--><=
span
class=3DEmailStyle18><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial'><![if =
!supportEmptyParas]>&nbsp;<![endif]><o:p></o:p></span></font></span></p>

<p class=3DMsoNormal style=3D'margin-left:.5in'><font size=3D2 =
color=3Dblack
face=3DTahoma><span =
style=3D'font-size:10.0pt;font-family:Tahoma;color:black'>-----Original
Message-----<br>
<b><span style=3D'font-weight:bold'>From:</span></b> Cousins, Michael
[mailto:Michael.Cousins@Cognos.COM]<br>
<b><span style=3D'font-weight:bold'>Sent:</span></b> Thursday, April 24, =
2003
1:16 PM<br>
<b><span style=3D'font-weight:bold'>To:</span></b> 'Daniel Mielke'; =
David
Morrison - Corporate; Powerhouse List (E-mail)<br>
<b><span style=3D'font-weight:bold'>Subject:</span></b> RE: QTP 6.07F on =
AS/400
sort sequence</span></font></p>

<p class=3DMsoNormal style=3D'margin-left:.5in'><font size=3D3 =
face=3D"Times New Roman"><span
style=3D'font-size:12.0pt'><![if =
!supportEmptyParas]>&nbsp;<![endif]><o:p></o:p></span></font></p>

<p class=3DMsoNormal style=3D'margin-left:.5in'><font size=3D3 =
color=3Dblack
face=3D"Times New Roman"><span =
style=3D'font-size:12.0pt;color:black'><![if =
!supportEmptyParas]>&nbsp;<![endif]></span></font><font
color=3Dblack><span =
style=3D'color:black;mso-color-alt:windowtext'><o:p></o:p></span></font><=
/p>

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.<o:p></o:p><=
/p>

<p style=3D'margin-left:.5in'><font size=3D2 color=3Dblack face=3D"Times =
New Roman"><span
style=3D'font-size:10.0pt;color:black'>You may want to try defining the =
index in
pdl.</span></font><font color=3Dblack><span style=3D'color:black'> =
</span></font><font
color=3Dblack><span =
style=3D'color:black;mso-color-alt:windowtext'><o:p></o:p></span></font><=
/p>

Index RAT-IDX [index options... =
] 
&nbsp;SEGMENT rat-no [datatype...] 
&nbsp;SEGMENT ratlet-name [datatype...] =
DESCENDING <o:p></o:p><=
/p>

<p style=3D'margin-left:.5in'><font size=3D2 color=3Dblack face=3D"Times =
New Roman"><span
style=3D'font-size:10.0pt;color:black'>This will affect all programs =
reading this
file via this index.</span></font><font color=3Dblack><span =
style=3D'color:black'> </span></font><font
color=3Dblack><span =
style=3D'color:black;mso-color-alt:windowtext'><o:p></o:p></span></font><=
/p>

<p style=3D'margin-left:.5in'><font size=3D2 color=3Dblack face=3D"Times =
New Roman"><span
style=3D'font-size:10.0pt;color:black'>-----Original =
Message-----</span></font><font
color=3Dblack><span style=3D'color:black'> <br>
</span></font><font size=3D2 color=3Dblack><span =
style=3D'font-size:10.0pt;
color:black'>From: Daniel Mielke [<a =
href=3D"mailto:DMielke@aic.com">mailto:DMielke@aic.com</a>]</span></font>=
<font
color=3Dblack><span style=3D'color:black'> <br>
</span></font><font size=3D2 color=3Dblack><span =
style=3D'font-size:10.0pt;
color:black'>Sent: Thursday, April 24, 2003 3:40 PM</span></font><font
color=3Dblack><span style=3D'color:black'> <br>
</span></font><font size=3D2 color=3Dblack><span =
style=3D'font-size:10.0pt;
color:black'>To: 'David Morrison - Corporate'; Powerhouse List =
(E-mail)</span></font><font
color=3Dblack><span style=3D'color:black'> <br>
</span></font><font size=3D2 color=3Dblack><span =
style=3D'font-size:10.0pt;
color:black'>Subject: RE: QTP 6.07F on AS/400 sort =
sequence</span></font><font
color=3Dblack><span style=3D'color:black'> </span></font><font =
color=3Dblack><span
style=3D'color:black;mso-color-alt:windowtext'><o:p></o:p></span></font><=
/p>

<p class=3DMsoNormal style=3D'margin-left:.5in'><font size=3D3 =
color=3Dblack
face=3D"Times New Roman"><span =
style=3D'font-size:12.0pt;color:black'><![if =
!supportEmptyParas]>&nbsp;<![endif]></span></font><font
color=3Dblack><span =
style=3D'color:black;mso-color-alt:windowtext'><o:p></o:p></span></font><=
/p>

<p style=3D'margin-left:.5in'><font size=3D2 color=3Dblack face=3D"Times =
New Roman"><span
style=3D'font-size:10.0pt;color:black'>Thanks David,</span></font><font
color=3Dblack><span style=3D'color:black'> </span></font><font =
color=3Dblack><span
style=3D'color:black;mso-color-alt:windowtext'><o:p></o:p></span></font><=
/p>

<p style=3D'margin-left:.5in'><font size=3D2 color=3Dblack face=3D"Times =
New Roman"><span
style=3D'font-size:10.0pt;color:black'>Get this..</span></font><font =
color=3Dblack><span
style=3D'color:black'> </span></font><font color=3Dblack><span =
style=3D'color:black;
mso-color-alt:windowtext'><o:p></o:p></span></font></p>

<p style=3D'margin-left:.5in'><font size=3D2 color=3Dblack face=3D"Times =
New Roman"><span
style=3D'font-size:10.0pt;color:black'>RAT-DATA is loaded by QTP sorting =
on
rat-no, ratlet-name.&nbsp; Temporary item</span></font><font =
color=3Dblack><span
style=3D'color:black'> <br>
</span></font><font size=3D2 color=3Dblack><span =
style=3D'font-size:10.0pt;
color:black'>t-rat-group ascends at rat-name during QTP to provide value =
to
rat-group.</span></font><font color=3Dblack><span style=3D'color:black'> =
</span></font><font
color=3Dblack><span =
style=3D'color:black;mso-color-alt:windowtext'><o:p></o:p></span></font><=
/p>

<p style=3D'margin-left:.5in'><font size=3D2 color=3Dblack face=3D"Times =
New Roman"><span
style=3D'font-size:10.0pt;color:black'>RAT-DATA</span></font><font =
color=3Dblack><span
style=3D'color:black'> <br>
</span></font><font size=3D2 color=3Dblack><span =
style=3D'font-size:10.0pt;
color:black'>rat-no ratlet-name rat-group =
other-rat-data</span></font><font
color=3Dblack><span style=3D'color:black'> <br>
</span></font><font size=3D2 color=3Dblack><span =
style=3D'font-size:10.0pt;
color:black'>000001 2pac&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
1</span></font><font
color=3Dblack><span style=3D'color:black'> <br>
</span></font><font size=3D2 color=3Dblack><span =
style=3D'font-size:10.0pt;
color:black'>000001 Alice&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
2</span></font><font
color=3Dblack><span style=3D'color:black'> <br>
</span></font><font size=3D2 color=3Dblack><span =
style=3D'font-size:10.0pt;
color:black'>000001 Alice&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
2</span></font><font
color=3Dblack><span style=3D'color:black'> <br>
</span></font><font size=3D2 color=3Dblack><span =
style=3D'font-size:10.0pt;
color:black'>000001 Pet2nia&nbsp;&nbsp;&nbsp;&nbsp;
3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span></font><font
color=3Dblack><span style=3D'color:black'><br>
</span></font><font size=3D2 color=3Dblack><span =
style=3D'font-size:10.0pt;
color:black'>000001 Pet2nia&nbsp;&nbsp;&nbsp;&nbsp; 3</span></font><font
color=3Dblack><span style=3D'color:black'> <br>
</span></font><font size=3D2 color=3Dblack><span =
style=3D'font-size:10.0pt;
color:black'>000001 Petunia&nbsp;&nbsp;&nbsp;&nbsp; 4</span></font><font
color=3Dblack><span style=3D'color:black'> <br>
</span></font><font size=3D2 color=3Dblack><span =
style=3D'font-size:10.0pt;
color:black'>000001 Petunia&nbsp;&nbsp;&nbsp;&nbsp; 4</span></font><font
color=3Dblack><span style=3D'color:black'> </span></font><font =
color=3Dblack><span
style=3D'color:black;mso-color-alt:windowtext'><o:p></o:p></span></font><=
/p>

<p style=3D'margin-left:.5in'><font size=3D2 color=3Dblack face=3D"Times =
New Roman"><span
style=3D'font-size:10.0pt;color:black'>RAT-IDX index is keyed by rat-no,
ratlet-name.&nbsp; Logical file(as400) is</span></font><font =
color=3Dblack><span
style=3D'color:black'> <br>
</span></font><font size=3D2 color=3Dblack><span =
style=3D'font-size:10.0pt;
color:black'>SRTSEQ(*HEX)</span></font><font color=3Dblack><span
style=3D'color:black'> </span></font><font color=3Dblack><span =
style=3D'color:black;
mso-color-alt:windowtext'><o:p></o:p></span></font></p>

<p style=3D'margin-left:.5in'><font size=3D2 color=3Dblack face=3D"Times =
New Roman"><span
style=3D'font-size:10.0pt;color:black'>First record that quiz pulls =
using
&quot;choose viaindex RAT-IDX rat-no 000001&quot;</span></font><font
color=3Dblack><span style=3D'color:black'> <br>
</span></font><font size=3D2 color=3Dblack><span =
style=3D'font-size:10.0pt;
color:black'>is Alice and not the expected 2pac.</span></font><font
color=3Dblack><span style=3D'color:black'> </span></font><font =
color=3Dblack><span
style=3D'color:black;mso-color-alt:windowtext'><o:p></o:p></span></font><=
/p>

<p style=3D'margin-left:.5in'><font size=3D2 color=3Dblack face=3D"Times =
New Roman"><span
style=3D'font-size:10.0pt;color:black'>Any comments?&nbsp; Ideas as to =
where
&quot;code page&quot; is located for AS400 version</span></font><font
color=3Dblack><span style=3D'color:black'> <br>
</span></font><font size=3D2 color=3Dblack><span =
style=3D'font-size:10.0pt;
color:black'>(as per Michael's comment attached)?</span></font><font
color=3Dblack><span style=3D'color:black'> </span></font><font =
color=3Dblack><span
style=3D'color:black;mso-color-alt:windowtext'><o:p></o:p></span></font><=
/p>

<p class=3DMsoNormal =
style=3D'mso-margin-top-alt:0in;margin-right:0in;margin-bottom:
12.0pt;margin-left:.5in'><font size=3D3 color=3Dblack face=3D"Times New =
Roman"><span
style=3D'font-size:12.0pt;color:black'><![if =
!supportEmptyParas]>&nbsp;<![endif]></span></font><font
color=3Dblack><span =
style=3D'color:black;mso-color-alt:windowtext'><o:p></o:p></span></font><=
/p>

<p style=3D'margin-left:.5in'><font size=3D2 color=3Dblack face=3D"Times =
New Roman"><span
style=3D'font-size:10.0pt;color:black'>-----Original =
Message-----</span></font><font
color=3Dblack><span style=3D'color:black'> <br>
</span></font><font size=3D2 color=3Dblack><span =
style=3D'font-size:10.0pt;
color:black'>From: Cousins, Michael [<a =
href=3D"mailto:Michael.Cousins@Cognos.COM">mailto:Michael.Cousins@Cognos.=
COM</a>]</span></font><font
color=3Dblack><span style=3D'color:black'> <br>
</span></font><font size=3D2 color=3Dblack><span =
style=3D'font-size:10.0pt;
color:black'>Sent: Thursday, April 24, 2003 2:44 PM</span></font><font
color=3Dblack><span style=3D'color:black'> <br>
</span></font><font size=3D2 color=3Dblack><span =
style=3D'font-size:10.0pt;
color:black'>To: 'Daniel Mielke'</span></font><font color=3Dblack><span
style=3D'color:black'> <br>
</span></font><font size=3D2 color=3Dblack><span =
style=3D'font-size:10.0pt;
color:black'>Subject: RE: QTP 6.07F on AS/400 sort =
sequence</span></font><font
color=3Dblack><span style=3D'color:black'> </span></font><font =
color=3Dblack><span
style=3D'color:black;mso-color-alt:windowtext'><o:p></o:p></span></font><=
/p>

<p class=3DMsoNormal style=3D'margin-left:.5in'><font size=3D3 =
color=3Dblack
face=3D"Times New Roman"><span =
style=3D'font-size:12.0pt;color:black'><![if =
!supportEmptyParas]>&nbsp;<![endif]></span></font><font
color=3Dblack><span =
style=3D'color:black;mso-color-alt:windowtext'><o:p></o:p></span></font><=
/p>

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. <o:p></o:p>

<p class=3DMsoNormal style=3D'margin-left:.5in'><font size=3D3 =
color=3Dblack
face=3D"Times New Roman"><span =
style=3D'font-size:12.0pt;color:black'><![if =
!supportEmptyParas]>&nbsp;<![endif]></span></font><font
color=3Dblack><span =
style=3D'color:black;mso-color-alt:windowtext'><o:p></o:p></span></font><=
/p>

<p style=3D'margin-left:.5in'><font size=3D2 color=3Dblack face=3D"Times =
New Roman"><span
style=3D'font-size:10.0pt;color:black'>-----Original =
Message-----</span></font><font
color=3Dblack><span style=3D'color:black'> <br>
</span></font><font size=3D2 color=3Dblack><span =
style=3D'font-size:10.0pt;
color:black'>From: David Morrison - Corporate [<a
href=3D"mailto:dmorrison@mcbrideelectric.com">mailto:dmorrison@mcbrideele=
ctric.com</a>]</span></font><font
color=3Dblack><span style=3D'color:black'> <br>
</span></font><font size=3D2 color=3Dblack><span =
style=3D'font-size:10.0pt;
color:black'>Sent: Thursday, April 24, 2003 3:13 PM</span></font><font
color=3Dblack><span style=3D'color:black'> <br>
</span></font><font size=3D2 color=3Dblack><span =
style=3D'font-size:10.0pt;
color:black'>To: Daniel Mielke; Powerhouse List =
(E-mail)</span></font><font
color=3Dblack><span style=3D'color:black'> <br>
</span></font><font size=3D2 color=3Dblack><span =
style=3D'font-size:10.0pt;
color:black'>Subject: RE: QTP 6.07F on AS/400 sort =
sequence</span></font><font
color=3Dblack><span style=3D'color:black'> </span></font><font =
color=3Dblack><span
style=3D'color:black;mso-color-alt:windowtext'><o:p></o:p></span></font><=
/p>

<p class=3DMsoNormal style=3D'margin-left:.5in'><font size=3D3 =
color=3Dblack
face=3D"Times New Roman"><span =
style=3D'font-size:12.0pt;color:black'><![if =
!supportEmptyParas]>&nbsp;<![endif]></span></font><font
color=3Dblack><span =
style=3D'color:black;mso-color-alt:windowtext'><o:p></o:p></span></font><=
/p>

<p style=3D'margin-left:.5in'><font size=3D2 color=3Dblack face=3D"Times =
New Roman"><span
style=3D'font-size:10.0pt;color:black'>Daniel,</span></font><font =
color=3Dblack><span
style=3D'color:black'> </span></font><font color=3Dblack><span =
style=3D'color:black;
mso-color-alt:windowtext'><o:p></o:p></span></font></p>

<p style=3D'margin-left:.5in'><font size=3D2 color=3Dblack face=3D"Times =
New Roman"><span
style=3D'font-size:10.0pt;color:black'>It uses the EBCDIC sort =
sequence.&nbsp;
Letters before numbers.&nbsp; You may be able</span></font><font =
color=3Dblack><span
style=3D'color:black'> <br>
</span></font><font size=3D2 color=3Dblack><span =
style=3D'font-size:10.0pt;
color:black'>to change this, in your data dictionary, but I'd recommend =
against
it.&nbsp; If</span></font><font color=3Dblack><span =
style=3D'color:black'> <br>
</span></font><font size=3D2 color=3Dblack><span =
style=3D'font-size:10.0pt;
color:black'>you have a particular need in one program to sort =
differently, I'd
create a</span></font><font color=3Dblack><span style=3D'color:black'> =
<br>
</span></font><font size=3D2 color=3Dblack><span =
style=3D'font-size:10.0pt;
color:black'>temporary field and sort on that field, =
instead.</span></font><font
color=3Dblack><span style=3D'color:black'> </span></font><font =
color=3Dblack><span
style=3D'color:black;mso-color-alt:windowtext'><o:p></o:p></span></font><=
/p>

<p style=3D'margin-left:.5in'><font size=3D2 color=3Dblack face=3D"Times =
New Roman"><span
style=3D'font-size:10.0pt;color:black'>David Morrison</span></font><font
color=3Dblack><span style=3D'color:black'> <br>
</span></font><font size=3D2 color=3Dblack><span =
style=3D'font-size:10.0pt;
color:black'>McBride Electric</span></font><font color=3Dblack><span
style=3D'color:black'> </span></font><font color=3Dblack><span =
style=3D'color:black;
mso-color-alt:windowtext'><o:p></o:p></span></font></p>

<p style=3D'margin-left:.5in'><font size=3D2 color=3Dblack face=3D"Times =
New Roman"><span
style=3D'font-size:10.0pt;color:black'>&nbsp;-----Original =
Message-----</span></font><font
color=3Dblack><span style=3D'color:black'> <br>
</span></font><font size=3D2 color=3Dblack><span =
style=3D'font-size:10.0pt;
color:black'>From: &nbsp; Daniel Mielke [<a =
href=3D"mailto:DMielke@aic.com">mailto:DMielke@aic.com</a>]
</span></font><font color=3Dblack><span style=3D'color:black'><br>
</span></font><font size=3D2 color=3Dblack><span =
style=3D'font-size:10.0pt;
color:black'>Sent:&nbsp;&nbsp; Thursday, April 24, 2003 11:33 =
AM</span></font><font
color=3Dblack><span style=3D'color:black'> <br>
</span></font><font size=3D2 color=3Dblack><span =
style=3D'font-size:10.0pt;
color:black'>To:&nbsp;&nbsp;&nbsp;&nbsp; Powerhouse List =
(E-mail)</span></font><font
color=3Dblack><span style=3D'color:black'> <br>
</span></font><font size=3D2 color=3Dblack><span =
style=3D'font-size:10.0pt;
color:black'>Subject:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; QTP =
6.07F on
AS/400 sort sequence</span></font><font color=3Dblack><span =
style=3D'color:black'> </span></font><font
color=3Dblack><span =
style=3D'color:black;mso-color-alt:windowtext'><o:p></o:p></span></font><=
/p>

<p style=3D'margin-left:.5in'><font size=3D2 color=3Dblack face=3D"Times =
New Roman"><span
style=3D'font-size:10.0pt;color:black'>Hi all,</span></font><font =
color=3Dblack><span
style=3D'color:black'> </span></font><font color=3Dblack><span =
style=3D'color:black;
mso-color-alt:windowtext'><o:p></o:p></span></font></p>

<p style=3D'margin-left:.5in'><font size=3D2 color=3Dblack face=3D"Times =
New Roman"><span
style=3D'font-size:10.0pt;color:black'>Is the sort sequence for PH fixed =
or
system determined?</span></font><font color=3Dblack><span =
style=3D'color:black'> </span></font><font
color=3Dblack><span =
style=3D'color:black;mso-color-alt:windowtext'><o:p></o:p></span></font><=
/p>

<p style=3D'margin-left:.5in'><font size=3D2 color=3Dblack face=3D"Times =
New Roman"><span
style=3D'font-size:10.0pt;color:black'>I have an alphanumeric field that =
contains
A-Z as well as 0-9.&nbsp; So for</span></font><font color=3Dblack><span
style=3D'color:black'> <br>
</span></font><font size=3D2 color=3Dblack><span =
style=3D'font-size:10.0pt;
color:black'>example, I have three records as below, what would the PH =
sort order
be for</span></font><font color=3Dblack><span style=3D'color:black'> =
<br>
</span></font><font size=3D2 color=3Dblack><span =
style=3D'font-size:10.0pt;
color:black'>&quot;sort on alpha-data-field&quot;?</span></font><font
color=3Dblack><span style=3D'color:black'> </span></font><font =
color=3Dblack><span
style=3D'color:black;mso-color-alt:windowtext'><o:p></o:p></span></font><=
/p>

<p style=3D'margin-left:.5in'><font size=3D2 color=3Dblack face=3D"Times =
New Roman"><span
style=3D'font-size:10.0pt;color:black'>alpha-data-field</span></font><fon=
t
color=3Dblack><span style=3D'color:black'> <br>
</span></font><font size=3D2 color=3Dblack><span =
style=3D'font-size:10.0pt;
color:black'>AJONES</span></font><font color=3Dblack><span =
style=3D'color:black'> <br>
</span></font><font size=3D2 color=3Dblack><span =
style=3D'font-size:10.0pt;
color:black'>aJONES</span></font><font color=3Dblack><span =
style=3D'color:black'> <br>
</span></font><font size=3D2 color=3Dblack><span =
style=3D'font-size:10.0pt;
color:black'>1JONES</span></font><font color=3Dblack><span =
style=3D'color:black'> </span></font><font
color=3Dblack><span =
style=3D'color:black;mso-color-alt:windowtext'><o:p></o:p></span></font><=
/p>

<p class=3DMsoNormal style=3D'margin-left:.5in'><font size=3D3 =
color=3Dblack
face=3D"Times New Roman"><span =
style=3D'font-size:12.0pt;color:black'><![if =
!supportEmptyParas]>&nbsp;<![endif]></span></font><font
color=3Dblack><span =
style=3D'color:black;mso-color-alt:windowtext'><o:p></o:p></span></font><=
/p>

&gt; BUY. HOLD. AND =
PROSPER. 
&gt; 
&gt; Daniel Mielke 
&gt; Business Systems Analyst 
&gt; AIC Limited 
&gt; 1-888-710-4242 (4614) 
&gt; dmielke@aic.com 
&gt; www.aic.com 
&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 
Mailing list: powerh-l@lists.swau.edu 
Subscribe: &quot;subscribe&quot; in message body to
powerh-l-request@lists.swau.edu 
Unsubscribe: &quot;unsubscribe &lt;password&gt;&quot; in =
message
body to =
 
powerh-l-request@lists.swau.edu 
<a href=3D"http://lists.swau.edu/mailman/listinfo/powerh-l"
target=3D"_blank">http://lists.swau.edu/mailman/listinfo/powerh-l</a></sp=
an> 
This list is closed, thus to post to the list you must be a
subscriber. <o:p></o:p><=
/p>

<p class=3DMsoNormal style=3D'margin-left:.5in'><font size=3D3 =
color=3Dblack
face=3D"Times New Roman"><span =
style=3D'font-size:12.0pt;color:black'><![if =
!supportEmptyParas]>&nbsp;<![endif]></span></font><font
color=3Dblack><span =
style=3D'color:black;mso-color-alt:windowtext'><o:p></o:p></span></font><=
/p>

<p style=3D'margin-left:.5in'><font size=3D2 color=3Dblack face=3D"Times =
New Roman"><span
style=3D'font-size:10.0pt;color:black'>__________________________________=
_______________</span></font><font
color=3Dblack><span style=3D'color:black'> <br>
</span></font><font size=3D2 color=3Dblack><span =
style=3D'font-size:10.0pt;
color:black'>Scanned for viruses on 24 Apr 2003 =
18:43:19</span></font><font
color=3Dblack><span style=3D'color:black'> <br>
</span></font><font size=3D2 color=3Dblack><span =
style=3D'font-size:10.0pt;
color:black'>No viruses found.</span></font><font color=3Dblack><span
style=3D'color:black'> <br>
</span></font><font size=3D2 color=3Dblack><span =
style=3D'font-size:10.0pt;
color:black'>Virus scanning by <a href=3D"http://erado.com" =
target=3D"_blank">http://erado.com</a></span></font><font
color=3Dblack><span style=3D'color:black'> </span></font><font =
color=3Dblack><span
style=3D'color:black;mso-color-alt:windowtext'><o:p></o:p></span></font><=
/p>

<p style=3D'margin-left:.5in'><font size=3D2 color=3Dblack face=3D"Times =
New Roman"><span
style=3D'font-size:10.0pt;color:black'>=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</span></font><font color=3Dblack><span =
style=3D'color:black'> <br>
</span></font><font size=3D2 color=3Dblack><span =
style=3D'font-size:10.0pt;
color:black'>Mailing list: powerh-l@lists.swau.edu</span></font><font
color=3Dblack><span style=3D'color:black'> <br>
</span></font><font size=3D2 color=3Dblack><span =
style=3D'font-size:10.0pt;
color:black'>Subscribe: &quot;subscribe&quot; in message body to
powerh-l-request@lists.swau.edu</span></font><font color=3Dblack><span
style=3D'color:black'> <br>
</span></font><font size=3D2 color=3Dblack><span =
style=3D'font-size:10.0pt;
color:black'>Unsubscribe: &quot;unsubscribe &lt;password&gt;&quot; in =
message
body to powerh-l-request@lists.swau.edu</span></font><font =
color=3Dblack><span
style=3D'color:black'> <br>
</span></font><font size=3D2 color=3Dblack><span =
style=3D'font-size:10.0pt;
color:black'><a href=3D"http://lists.swau.edu/mailman/listinfo/powerh-l"
target=3D"_blank">http://lists.swau.edu/mailman/listinfo/powerh-l</a></sp=
an></font><font
color=3Dblack><span style=3D'color:black'> <br>
</span></font><font size=3D2 color=3Dblack><span =
style=3D'font-size:10.0pt;
color:black'>This list is closed, thus to post to the list you must be a
subscriber.</span></font><font color=3Dblack><span =
style=3D'color:black'> </span></font><font
color=3Dblack><span =
style=3D'color:black;mso-color-alt:windowtext'><o:p></o:p></span></font><=
/p>

<p style=3D'margin-left:.5in'><font size=3D2 color=3Dblack face=3D"Times =
New Roman"><span
style=3D'font-size:10.0pt;color:black'>This message may contain =
privileged and/or
confidential information.&nbsp; 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.&nbsp;
Thank you.</span></font><font color=3Dblack><span =
style=3D'color:black;mso-color-alt:
windowtext'><o:p></o:p></span></font></p>

</div>

</body>

</html>
<BR><BR>_________________________________________________
<BR>Scanned for viruses on 24 Apr 2003 20:20:01
<BR>No viruses found.
<BR>Virus scanning by <A href=3Dhttp://erado.com>http://erado.com</A>
------_=_NextPart_001_01C30AA0.0897D068--