Hard to follow exactly what you mean. For example, by "temporary sequential file", are you saying that if you add a SEQ stage between *every* transform, essentially writting all rows to disk and then reading then back in between transforms, then it *works*? [?]
I've seen differences in behaviour between Director and Debugger in the past, but it's been a looong time. What version of DataStage are you running, and what is your platform?
-craig
Sequential file EOF problem
Moderators: chulett, rschirm, roy
Hi,
Try going to the Performance tab in Job Properties of the job. This is the active-to-active link performance section. Make sure you have the following selected:
Enable row buffer
In Process
128kb buffer
I think the reason for your problem is that your going from active-to-active stages with either no row buffering or inter processing. This is why when you "land" the data in intermediate sequential files, it comes out correctly. Anyway, give that a try. I think that will solve the problem
LD
Try going to the Performance tab in Job Properties of the job. This is the active-to-active link performance section. Make sure you have the following selected:
Enable row buffer
In Process
128kb buffer
I think the reason for your problem is that your going from active-to-active stages with either no row buffering or inter processing. This is why when you "land" the data in intermediate sequential files, it comes out correctly. Anyway, give that a try. I think that will solve the problem
LD
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: