Craig,

Thank you for offering up the winning solution. This worked beautifully and
will be tucked away in my little bag of tricks forever more.

Paul Scott
Problem Solved
ph:      707-451-2611
fax:     707-471-6553
pager: 888-541-3477
[log in to unmask]


-----Original Message-----
From: :-) Craig Lalley [mailto:[log in to unmask]]
Sent: Monday, February 17, 2003 5:46 PM
To: Paul Scott; [log in to unmask]
Subject: Re: sort


Paul,

I think your problem is that you are attempting to sort a variable
length record.

When doing that you should use the syntax

>input pmstemp,#numrec,rec-size

Where rec-size is:

A positive integer specifying the maximum allowable number of bytes in
a record. This parameter may be used to set the record size of the
output file, but is used mainly for files containing variable-length
records. When sorting such files, this parameter should be set to the
size of the largest record present in the input. If rec size is not
specified when sorting variable-length record files, SORT/XL will use
the block size as the maximum record size. This could result in more
space than necessary being used for the scratch file, as well as
causing some degradation of performance.

In this case the large rec-size it probably causing issue.

Regards,

-Craig



--- Paul Scott <[log in to unmask]> wrote:
> Sorry to get on-topic, but I'm running into trouble at 6.5 sorting a
> large
> file and I was hoping someone would have some input... I have tons of
> contiguous space on that volume set. I've tried setting the ;STACK=
> on RUN
> SORT.PUB.SYS, but nothing is working.
>
> Thanks in advance,
>
> Paul Scott
> Problem Solved
> ph:      707-451-2611
> fax:     707-471-6553
> pager: 888-541-3477
> [log in to unmask]
>
>
> [MGR.CU1,CONVERT]:lf pmstemp
> ACCOUNT=  CU1         GROUP=  CONVERT
>
> FILENAME  CODE  ------------LOGICAL RECORD-----------  ----SPACE----
>                   SIZE  TYP        EOF      LIMIT R/B  SECTORS #X MX
>
> PMSTEMP         10000B  VA       35964     100000   1    10240  8 32
>
>
> [MGR.CU1,CONVERT]: sort
> HP31900A.02.00  TurboSORT MON, FEB 17, 2003,  5:02 PM
> (C) HEWLETT-PACKARD CO. 1987
>
> >input pmstemp
> >output pmstemp1
> >key 5,9,b
> >verify
>
> INPUT FILE = PMSTEMP
> RECORD LENGTH = SAME AS THAT OF THE INPUT FILE
> OUTPUT FILE = PMSTEMP1
> KEY POSITION   LENGTH     TYPE    ASC/DESC
>         5         9       BYTE       ASC   (MAJOR KEY)
>
> >end
> SORTLIB: INSUFFICIENT STACK SPACE
> Program terminated in an error state. (CIERR 976)
> [MGR.CU1,CONVERT]:
>
> * To join/leave the list, search archives, change list settings, *
> * etc., please visit http://raven.utc.edu/archives/hp3000-l.html *


__________________________________________________
Do you Yahoo!?
Yahoo! Shopping - Send Flowers for Valentine's Day
http://shopping.yahoo.com

* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *