<br><font size=2 face="sans-serif">Hi,</font>
<br>
<br><font size=2 face="sans-serif">What I do recall is that the sort file
has to have a contiguous disc space.</font>
<br>
<br><font size=2 face="sans-serif">You can avoid the sort by creating the
file with a key (I think this was mentioned very recently) and access by
key and it will be accessed in a sorted sequence, without performing a
sort.</font>
<br>
<br><font size=2 face="sans-serif">There is another little quirk that you
can add, which is a file equate when using in QTP, provided used for that
QTP only.</font>
<br>
<br>
<br><font size=2 face="sans-serif">FILE fn;NOLOCK;EXC</font>
<br>
<br><font size=2 face="sans-serif">e.g.</font>
<br>
<br><font size=2 face="sans-serif">The following is purely for HP under
MPE.</font>
<br>
<br><font size=2 face="sans-serif">FILE bb;nolock;exc</font>
<br>
<br><font size=2 face="sans-serif">Req r1</font>
<br>
<br><font size=2 face="sans-serif">Access a</font>
<br>
<br><font size=2 face="sans-serif">temp yy char * 30</font>
<br><font size=2 face="sans-serif">item yy = y1 + y2 + y3</font>
<br><font size=2 face="sans-serif">sub bb incl xx, yy index yy</font>
<br>
<br><font size=2 face="sans-serif">req r2</font>
<br>
<br><font size=2 face="sans-serif">access *bb</font>
<br>
<br><font size=2 face="sans-serif">cho yy parm</font>
<br>
<br><font size=2 face="sans-serif">etc.</font>
<br>
<br>
<br><font size=2 face="sans-serif">I hope this helps. Please let me know
if my understanding needs correcting.</font>
<br>
<br><font size=2 face="sans-serif">Nilesh.</font>
<br>
<br>
<br>
<br>
<br>
<br><font size=6 color=#006000 face="Tahoma"><b>E</b></font><font size=5 color=#006000 face="Tahoma">xtranet</font>
<br><font size=1 face="sans-serif">pfbcs@hotmail.com@lists.sowder.com -
15/02/2006 03:50</font>
<br><font size=1 face="sans-serif"> </font>
<p><font size=1 color=#800080 face="sans-serif">Sent by:
powerh-l-bounces+nilesh.patel=bnpparibas.com@lists.sowder.com</font>
<p><font size=1 color=#800080 face="sans-serif">To:
</font><font size=1 face="sans-serif">powerh-l</font>
<p><font size=1 color=#800080 face="sans-serif">cc:
</font>
<p><font size=1 color=#800080 face="sans-serif">Subject:
</font><font size=1 face="sans-serif"><b>RE: Sort
file limit -- QTP 843D</b></font>
<br>
<br>
<br><font size=2><tt>Hi all:<br>
</tt></font>
<br><font size=2><tt>Thanks for the many suggestiions with regard to this
problem.<br>
</tt></font>
<br><font size=2><tt>I have chosen to reduce the record size of QTPSORT<br>
by writing only the items that I need to a subfile;<br>
then in next request read and sort the subfile and do the<br>
output processing.<br>
</tt></font>
<br><font size=2><tt>By the way I am looking for a new gig.<br>
</tt></font>
<br><font size=2><tt>Regards,<br>
Peter<br>
><br>
># of records. = 4,437,271<br>
> rec size
= 584<br>
><br>
>file size
= 2,591,366,264<br>
><br>
>Even though I have PHTEMP point to a very large file system.<br>
><br>
>I get :-<br>
><br>
>Insufficient disk space for sort.<br>
><br>
>Regards,<br>
>Peter<br>
><br>
</tt></font>
<br><font size=2><tt>_________________________________________________________________<br>
Powerful Parental Controls Let your child discover the best the Internet
has<br>
to offer.<br>
http://join.msn.com/?pgmarket=en-ca&page=byoa/prem&xAPID=1994&DI=1034&SU=http://hotmail.com/enca&HL=Market_MSNIS_Taglines</tt></font>
<br><font size=2><tt>Start enjoying all the benefits of MSNŽ Premium right
now and get the<br>
first two months FREE*.<br>
</tt></font>
<br><font size=2><tt>--<br>
= = = = = = = = = = = = = = = = = = = = = = = = = = = =<br>
Mailing list: powerh-l@lists.sowder.com<br>
Subscribe: "subscribe" in message body to powerh-l-request@lists.sowder.com<br>
Unsubscribe: "unsubscribe &lt;password&gt;" in message
body to powerh-l-request@lists.sowder.com<br>
http://lists.sowder.com/mailman/listinfo/powerh-l</tt></font>
<br><font size=2><tt>This list is closed, thus to post to the list you
must be a subscriber.</tt></font>
<br><pre>
This message and any attachments (the "message") is
intended solely for the addressees and is confidential.
If you receive this message in error, please delete it and
immediately notify the sender. Any use not in accord with
its purpose, any dissemination or disclosure, either whole
or partial, is prohibited except formal approval. The internet
can not guarantee the integrity of this message.
BNP PARIBAS (and its subsidiaries) shall (will) not
therefore be liable for the message if modified.
---------------------------------------------
Ce message et toutes les pieces jointes (ci-apres le
"message") sont etablis a l'intention exclusive de ses
destinataires et sont confidentiels. Si vous recevez ce
message par erreur, merci de le detruire et d'en avertir
immediatement l'expediteur. Toute utilisation de ce
message non conforme a sa destination, toute diffusion
ou toute publication, totale ou partielle, est interdite, sauf
autorisation expresse. L'internet ne permettant pas
d'assurer l'integrite de ce message, BNP PARIBAS (et ses
filiales) decline(nt) toute responsabilite au titre de ce
message, dans l'hypothese ou il aurait ete modifie.
</pre>