Hi,
I want to transfer a complete batch of data over a link, instead of row by row. (The batch of data might be result of a query or say a lookup).
Usually what happens is that it just send the last row of a batch of rows.
Pelase suggest sth.
Thx.
Transfer a Batch of Data over a link
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 273
- Joined: Wed Oct 18, 2006 12:20 pm
- Location: Porto
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Not enough information. DataStage server jobs typically send rows; the number of rows in each "batch" is set by "array size" or some similarly-named property. If what you claim is true there is some problem with your configuration; you need to involve your support provider. There is no reason to lose rows during a transfer.
Do you get any warning messages? How did you determine that "the last of each batch of rows" was being transmitted? Was this into DataStage, out of DataStage, or both? To what value is array size property set?
Do you get any warning messages? How did you determine that "the last of each batch of rows" was being transmitted? Was this into DataStage, out of DataStage, or both? To what value is array size property set?
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.
'Complete batch'? I'm guessing from your 'usually it just send the last row of a batch of rows' comment that you want a lookup to return a 'multi-row result set'. If that's the case, there are pleny of conversations here on the subject that a search would turn up. And one of the first things you'll find is the fact that only two stages have that functionality - the ODBC stage and the UV stage.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Premium Member
- Posts: 273
- Joined: Wed Oct 18, 2006 12:20 pm
- Location: Porto
chulett wrote: 'Complete batch'? I'm guessing from your 'usually it just send the last row of a batch of rows' comment that you want a lookup to return a 'multi-row result set'. If that's the case, there are pleny of conversations here on the subject that a search would turn up. And one of the first things you'll find is the fact that only two stages have that functionality - the ODBC stage and the UV stage.
Yes, In my case lookup will return a 'multi-row result set'.
Can UV stage be used to connect to DB2?
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: