QTP 6.07F on AS/400 sort sequence

[David Morrison - Corporate]

Daniel,

If you ALWAYS want to sort your rats with digits before letters, as opposed to just in one report, then you may want to create a logical file with an alternative coding scheme on one field.  Check out the IBM documentation on the web to find out how to do this, in DDS.

If you mess with the OS/400 code page, you'll be affecting the entire system.   Use DSPSYSVAL QCHRID to see its value on your machine.

David Morrison
McBride Electric

 -----Original Message-----
From: 	Daniel Mielke [mailto:DMielke@aic.com] 
Sent:	Thursday, April 24, 2003 12: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



_________________________________________________
Scanned for viruses on 24 Apr 2003 19:43:46
No viruses found.
Virus scanning by http://erado.com