Sort file limit -- QTP 843D

[nilesh.patel at bnpparibas.com]

Hi,

What I do recall is that the sort file has to have a contiguous disc 
space.

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.

There is another little quirk that you can add, which is a file equate 
when using in QTP, provided used for that QTP only.


FILE fn;NOLOCK;EXC

e.g.

The following is purely for HP under MPE.

FILE bb;nolock;exc

Req r1

Access a

temp yy char * 30
item yy = y1 + y2 + y3
sub bb incl xx, yy index yy

req r2

access *bb

cho yy parm

etc.


I hope this helps. Please let me know if my understanding needs 
correcting.

Nilesh.





Extranet
pfbcs at hotmail.com@lists.sowder.com - 15/02/2006 03:50
 
Sent by: powerh-l-bounces+nilesh.patel=bnpparibas.com at lists.sowder.com
To:     powerh-l
cc: 
Subject:        RE: Sort file limit -- QTP 843D


Hi all:

Thanks for the many suggestiions with regard to this problem.

I have chosen to reduce the record size of QTPSORT
by writing only the items that I need to a subfile;
then in next request read and sort the subfile and do the
output processing.

By the way I am looking for a new gig.

Regards,
Peter
>
># of records.            =   4,437,271
>   rec size                 =   584
>
>file size                     = 2,591,366,264
>
>Even though I have PHTEMP point to a very large file system.
>
>I get :-
>
>Insufficient disk space for sort.
>
>Regards,
>Peter
>

_________________________________________________________________
Powerful Parental Controls Let your child discover the best the Internet 
has
to offer.
http://join.msn.com/?pgmarket=en-ca&page=byoa/prem&xAPID=1994&DI=1034&SU=http://hotmail.com/enca&HL=Market_MSNIS_Taglines
Start enjoying all the benefits of MSN® Premium right now and get the
first two months FREE*.

--
= = = = = = = = = = = = = = = = = = = = = = = = = = = =
Mailing list: powerh-l at lists.sowder.com
Subscribe: "subscribe" in message body to 
powerh-l-request at lists.sowder.com
Unsubscribe: "unsubscribe <password>" in message body to 
powerh-l-request at lists.sowder.com
http://lists.sowder.com/mailman/listinfo/powerh-l
This list is closed, thus to post to the list you must be a subscriber.


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.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.sowder.com/pipermail/powerh-l/attachments/20060215/e43cce78/attachment.htm