Hi,
Is there any way to do a Range Lookup when the reference link is either from a Sequential File stage or from a Data Set stage?
In Server jobs, we have written the records to a Hashed File and then read it through a UniVerse stage to accomplish a Range Lookup. Is there some kind of means to achieve it in a parallel job?
Thanks.
Range Lookup in a parallel job
Moderators: chulett, rschirm, roy
No, you cannot do a range lookup from a sequential or DataSet file in PX 7. You can use the same method you used in server jobs in PX - write to an SQL-capable source and use that in your lookup stage.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
ArndW,
Ok, you say to write it to a SQL-capable source and then do the Range Lookup. But there is no feature in parallel job to write to a Hashed File and then reading it using a stage like UniVerse stage.
So, is the only solution in parallel job is to write it to a database table and then read it from there?
Thanks for your inputs.
Ok, you say to write it to a SQL-capable source and then do the Range Lookup. But there is no feature in parallel job to write to a Hashed File and then reading it using a stage like UniVerse stage.
So, is the only solution in parallel job is to write it to a database table and then read it from there?
Thanks for your inputs.