Order by with select if in PHWeb

[Edis, Robert]

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.