Sequential file stage - mass change to incomplete column?

sbass1 · Post by **sbass1** » Wed Sep 16, 2009 10:06 pm

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

Couldn't DS have warned me on the first column rather than after changing 120 columns? Grrr...

chulett · Post by **chulett** » Wed Sep 16, 2009 10:31 pm

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.

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.

ray.wurlod · Post by **ray.wurlod** » Thu Sep 17, 2009 3:29 pm

I'm with Craig - I don't know a mass-change technique. I usually work from the bottom up (therefore up-arrow).

sbass1 · Post by **sbass1** » Fri Sep 18, 2009 1:58 am

Okie-doke, thanks...