Need you help on me using Dataset stage

hailun · Post by **hailun** » Fri Feb 25, 2011 12:27 am

Hi,

Currently the server version I'm am using is 7.5.1.A to oad data from tables to a data set file using Dataset stage. Is there any way to let the data set file have two exactly same columns(column types,column names .etc) by updating dataset stage?

Thanks

priyadharsini · Post by **priyadharsini** » Fri Feb 25, 2011 2:21 am

Dataset doesn't allow to have 2 columns with same name. Please be clear, are you going to have same value on two columns?

hailun · Post by **hailun** » Fri Feb 25, 2011 3:20 am

Hi Buddy,

Thanks for telling me it does not allow 2 columns with same name. I wanted it have two columns with same name and same value.

Thanks again man

ray.wurlod · Post by **ray.wurlod** » Fri Feb 25, 2011 3:53 am

DataStage is only following database rules - you can't have two columns with the same name in the one table, or two tables with the same name in the one schema, etc.

hailun · Post by **hailun** » Sun Feb 27, 2011 7:21 pm

Hi Ray,

Thank you for input, I am able to tell me that Datastage does not allow two columns with same name in a table or dataset

And so I am marking the topic close now.