For Missing Question

[Chris Sharman]

>I have a file that I want to display in a cluster where the order is 
>different than any of the indexes in the file. I have another file though 
>that I could use to "drive" this primary file so they would be retrieved in 
>the order I want. In this case I want to retrieve them in customer-num 
>order, which is not an index on WPS-PO-MST but is on GLS-PO-DRIVER.
>
>The driver file (GLS-PO-DRIVER) has multiple records for the same 
>VENDOR-NUM. After entering the VENDOR-NUM, then I do WHILE RETRIEVING for 
>all of these records and retrieve the primary record (WPS-PO-MST) and 
>display them.
>
>The problem I'm having is that it will only display up to the number of 
>records in the "cache" and no further. In the example below I've purposely 
>set the cache to a low number for testing purposes, but it works the same 
>way at 255. After displaying the last record in the cache, it starts over 
>with the first record.

If I understand correctly, that there's multiple gls-po-driver records for a
given vendor-num, and multiple wps-po-mst records per gls-po-driver record,
then I think you're kind of stuck.

The 'correct' solution, as you doubtless know, would be a repeating primary
gls-po-driver record, with a subscreen with one gls-po-driver master record & a
repeating primary wps-po-mst record.

If it's an ordering problem, Powerhouse has an 'orderby' clause for use with
some databases on some platforms, I believe, which would enable you to use
wps-po-mst directly as a repeating primary.

If neither of those are suitable, then I think you'll have to store some unique
id of the last record during postfind. Then when next is called, you skip up to
& including that record (probably using 'file wps-po-mst designer open 1 alias
skp'). A nasty fudge, and probably slow if you get up to thousands of records.

Alternatively, lobby Cognos to remove the 255 limit (hi, Bob). I suspect that
would expose a raft of memory problems though, and won't happen anytime soon.

Regards
Chris
_______________________________________________________________________
Chris.Sharman@CCAgroup.co.uk		http://www.ccagroup.co.uk/
CCA Stationery Ltd, Eastway, Fulwood, Preston, Lancashire, PR2 9WS.
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
This list is closed, thus to post to the list, you must be a subscriber.