Propagating Column Length in Next Stages
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 43
- Joined: Wed Feb 12, 2014 12:34 pm
- Location: Hyderabad, India
Propagating Column Length in Next Stages
Hi, I need to change a column length and type in all stages till Target from Source stage. There are many stages in between. Could anyone please advise is there any shortcut to propagate column attributes in next stages till target stage?
SyedMuhammadMehdi
Unfortunately not.
<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:
You could achieve this had you created your job design using runtime column propagation.
The DataStage flow designer (new in version 11.7) allows metadata propagation too.
However, there is nothing in DataStage that allows a manual change to be propagated through stages in which explicit column definitions occur.
That said, it would be possible to create a DataStage routine to achieve this. However, that routine would need to be re-written once IBM stops using the "UniVerse" database underneath the project.
The DataStage flow designer (new in version 11.7) allows metadata propagation too.
However, there is nothing in DataStage that allows a manual change to be propagated through stages in which explicit column definitions occur.
That said, it would be possible to create a DataStage routine to achieve this. However, that routine would need to be re-written once IBM stops using the "UniVerse" database underneath the project.
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.