Page 1 of 1

Need you help on me using Dataset stage

Posted: Fri Feb 25, 2011 12:27 am
by hailun
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

Posted: Fri Feb 25, 2011 2:21 am
by priyadharsini
Dataset doesn't allow to have 2 columns with same name. Please be clear, are you going to have same value on two columns?

Posted: Fri Feb 25, 2011 3:20 am
by hailun
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 :)

Posted: Fri Feb 25, 2011 3:53 am
by ray.wurlod
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.

Posted: Sun Feb 27, 2011 7:21 pm
by hailun
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.