DSXchange

We have approx. 4000 decimal and char type columns in a Sequential writer. All the columns are Nullable. I need to define the "Null Field Value" for each column thru Edit Column Meta Data. Most of the char columns are more than 20 bytes long. Is there is shortest way to put the spaces rather than pressing space bar equal to the length of the column. I saw in one of the post to put 19 "*" that means replicate 19 times spaces. It is treating like a literal when I used the same expression.
Please help me out on this.

Enter the 19 spaces then select them. Press Ctrl-C. Then, for all the others, press Ctrl-V. It's a technique called copy-and-paste.

But we have fields which have more than 19 bytes and one of the fields is 350 bytes in length.

ray.wurlod wrote:Enter the 19 spaces then select them. Press Ctrl-C. Then, for all the others, press Ctrl-V. It's a technique called copy-and-paste.

I dont know if this is the right way or not, but this is how we do it

open word document
press space bar, keep track of "Col" in the status bar, press space till Col shows 350 (for field of 350 characters)

Then use the windows' gift ctrl C ctrl V

nynali is this a parallel job or a server job? U have the same post in server and parallel forum and Job Type in both the forums is parallel.