Hashfile Lookup
Moderators: chulett, rschirm, roy
Hashfile Lookup
Is it possible to do a lookup on a hashfile to retrieve records between certain dates.....I am able to do what I want using a DB2 stage....but using a hashfile I cannot select the particular records I want......I used the account name option but it disables the selection when I use it as a lookup..... any suggestions ?
Hashed file lookups do not support a BETWEEN type of lookup. You can use the SQL query on a hashed file (ODBC or UniVerse stages), but the performance is going to be abyssmal (full table scan for each row). There are a number of solutions for better performance to this type of problem that have been covered before in this forum.
does that mean I am better off using my filtered DB2 stage as the lookup to do the same function ?
ArndW wrote:Hashed file lookups do not support a BETWEEN type of lookup. You can use the SQL query on a hashed file (ODBC or UniVerse stages), but the performance is going to be abyssmal (full table scan for each ...