Global Column Length Change

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
clarcombe
Premium Member
Premium Member
Posts: 515
Joined: Wed Jun 08, 2005 9:54 am
Location: Europe

Global Column Length Change

Post by clarcombe »

Hello

I have a varchar(20) that I have to change to a varchar(200). This is across multiple stages in a job and multiple jobs.

I only have Datastage (No metadata workbench etc). Is there some way to do this (simply)?

Thanks
Colin Larcombe
-------------------

Certified IBM Infosphere Datastage Developer
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

The new Data Flow Designer in version 11.7 features automatic propagation of metadata changes through a job design.

Otherwise you're probably looking at modifying an export file and importing the result.
Last edited by ray.wurlod on Fri Sep 14, 2018 2:15 am, edited 2 times in total.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
clarcombe
Premium Member
Premium Member
Posts: 515
Joined: Wed Jun 08, 2005 9:54 am
Location: Europe

Post by clarcombe »

Thanks Ray.

I can't see your full response, but I assume that you are saying to modify the dsx file. I thought I'd tried this before but never see the columns in the DSX file.

Anyway, maybe I can get the IT department to upgrade to 11.7
Colin Larcombe
-------------------

Certified IBM Infosphere Datastage Developer
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

You're a premium member; you should be able to see it all. In any case you couldn't have missed much, so I've opened the entire post.

It's the weekend where I am; I'll need to check once I get back on site on Monday.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
clarcombe
Premium Member
Premium Member
Posts: 515
Joined: Wed Jun 08, 2005 9:54 am
Location: Europe

Post by clarcombe »

I'm a lapsed premium member. :oops:

Thankyou for opening it and checking though Ray.
Colin Larcombe
-------------------

Certified IBM Infosphere Datastage Developer
Post Reply