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...
Sequential file stage - mass change to incomplete column?
Moderators: chulett, rschirm, roy
Sequential file stage - mass change to incomplete column?
Some people are the Michael Jordan's of Datastage. I'm more like Muggsy Bogues
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.
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.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: