Order by with select if in PHWeb

[Etienne Rompré]

No ,

The file does not need to be updated.  For display only.

Thanks!


-- 
Etienne Rompré
Directeur Marketing - Technologies
Marketing - Technologies Director

Kangouroute Inc. 
Location autos - camions
Car & Truck Rental
Québec Canada

tél: (418) 266-9500
fax: (418) 683-2610
courriel/email: rompre@kangouroute.com
internet:  http://www.kangouroute.com/



> But this would only work if the file was read only.  What if the primary
> record needs to be updated?
> 
> Blue
> 
> -----Original Message-----
> From: chuck.reinke [mailto:chuck.reinke@sbcglobal.net]
> Sent: Friday, May 30, 2003 9:54 AM
> To: powerh-l@lists.swau.edu
> Subject: Re: Order by with select if in PHWeb
> 
> 
> The Subfile technique should work, here is another suggestion of an
> approach:
> 
> The major challenge is efficiency.
> 
> 1 - In the Dictionary, declare an indexed file , indexed by the sort item.
> 2 - Construct an FDL to efficiently index this file.
> 3 - In the PostPath, do a WhileRetrieving on your current Primary file,
> include a Select clause with it, but make it a Designer File.
> 
> 4. At the beginning of the PostPath, create the file with and FDL command
> statement
> 5. During the WhileRetrieving, do Puts (don't for get the Reset verb) to
> this previously non-existent file
> 6. Access this file ViaIndex of the sort item (you don't need a select
> anymore)
> 7. In the Exit procedure, purge the file. You may wish to lock and unlock it
> as well.
> 
> I don't have a VMS system to try this out, but I've done it before with KSAM
> on an HP, and the technique is remarkably fast.
> 
> Chuck
> 
> = = = = = = = = = = = = = = = = = = = = = = = = = = = =
> 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.
> = = = = = = = = = = = = = = = = = = = = = = = = = = = =
> 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.
>