Page 1 of 1

Sequential file stage - mass change to incomplete column?

Posted: Wed Sep 16, 2009 10:06 pm
by sbass1
Hi,

In my sequential file stage with 120 columns, how do I globally change "Incomplete Column" from "Error" to "Replace + Warn", rather than the oh-so-painful one column at a time?

Thanks...

P.S.: My first change was from "Error" to "Retain", then I got the error message "...cannot retain incomplete columns as it is a delimited file".

So, this change is doubly painful :evil: Couldn't DS have warned me on the first column rather than after changing 120 columns? Grrr...

Posted: Wed Sep 16, 2009 10:31 pm
by chulett
There isn't a way that I know of, except perhaps to export / edit / import the dsx. I think I just got really good at the R-R-Enter-DownArrow key sequence. :wink:

ps. I prefer just 'Replace' without the pesky warning unless you really need to know that field is missing and possibly abort the job if enough occur.

Posted: Thu Sep 17, 2009 3:29 pm
by ray.wurlod
I'm with Craig - I don't know a mass-change technique. I usually work from the bottom up (therefore up-arrow).

Posted: Fri Sep 18, 2009 1:58 am
by sbass1
Okie-doke, thanks...