automatching columns with hyphens

tuj · Post by **tuj** » Tue May 23, 2006 8:28 am

Hi all. I am tring to redevelop some DataStage jobs and I am having trouble with the automatch in setting up the transform. My source is a CSV file, and my destination is DB2. Both table definitions contain multiple columns with hyphens in the names. When the automatch runs in the transform, it only matches up columns that are not hyphenated.

The problem is that I have A LOT of tables and columns like this, and I really don't want to have to set up each individual column, especially when the source and destination names are exactly the same!

Can someone give me some ideas as to how I can get around this problem? Thanks!

ArndW · Post by **ArndW** » Tue May 23, 2006 8:39 am

Can you use the positional matching instead? Also, as a last resort you might be able to create a .dsx export file and use a global replace in that text file and re-import it.

chulett · Post by **chulett** » Tue May 23, 2006 8:40 am

Hypens? As in dashes? I don't recall DataStage supporting column names with hyphens in them.

In any case, if they occur in the same order you can select them all from one side and 'drop' them on the other.