Sparse lookup possible in SE?
Moderators: chulett, rschirm, roy
Sparse lookup possible in SE?
I performed a search but could not find any information about sparse lookups in server edition. Does anyone know if it is possible? I know that PX has this option.
-
- Participant
- Posts: 437
- Joined: Fri Oct 15, 2004 6:13 am
- Location: Pune, India
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
ALL server job lookups are sparse, in that there is no intermediate virtual Data Set. As Kirtikumar notes, however, enabling row buffering has a similar effect to a virtual Data Set. Nevertheless, a query is executed against the database server (or hashed file) for each stream input row, buffering notwithstanding; therefore all server job lookups are technically sparse.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.