Page 1 of 1
Global Column Length Change
Posted: Mon Sep 10, 2018 5:37 am
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
Posted: Thu Sep 13, 2018 6:55 pm
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.
Posted: Fri Sep 14, 2018 12:25 am
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
Posted: Fri Sep 14, 2018 2:16 am
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.
Posted: Fri Sep 14, 2018 2:26 am
by clarcombe
I'm a lapsed premium member.
Thankyou for opening it and checking though Ray.