QTP 6.07F on AS/400 sort sequence

[David Morrison - Corporate]

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