QTP 6.07F on AS/400 sort sequence

[Merol Newman]

Hello Daniel

I knew I'd produced a reference file for this sort of thing once - I found it.
This was done on VMS, but you could always repeat the highly technical quiz code
:)

def x cha*1 = parm
rep sum all
set subfile append name xx
go      ;repeat go for each character to be sorted

access *xx
sort on x
rep all
go

  !
  "
  #
  $
  %
  &
  '     apostrophe
  (
  )
  *
  +
  ,     comma
  -     minus
  .
  /
  0
  1
  9
  :
  ;
  <
  =
  >
  ?
  @
  A
  Z
  [
  \
  ]
  ^
  _     underscore
  a
  z
  {
  |     vertical bar
  }

regards
Merol

merol.newman@ramesys.com
Ramesys, Eldon Way, Crick, Northamptonshire, UK. NN6 7SL
phone 01788 822133/823831, fax 01788 823601


-----Original Message-----
From: powerh-l-admin@cube.swau.edu
[mailto:powerh-l-admin@cube.swau.edu]On Behalf Of Daniel Mielke
Sent: 24 April 2003 19:33
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