Problem while displaying data into CSV

avneeshrai · Post by **avneeshrai** » Wed Jan 07, 2009 5:33 am

Hi all,
There is a column with datatype date in table,we are creating csv file as target and when tried to open csv file the records in same columns displaying as (00:00.0)instead of (2004-03-01 12:00:00 AM).

We have tried different ways by changing data type (Varchar, Date, Timestamp, Real, Nvharchar, Longvarchar) of the column in the csv file but result is same.

Can any one help me to solve it.
Thanks

ArndW · Post by **ArndW** » Wed Jan 07, 2009 6:04 am

If you take the problem a step at a time it might turn out to be a simple solution. What text is contained in this field in the CSV file? If you define that field as VarChar of appropriate length, what is displayed in the sequential file stage with view data?

chulett · Post by **chulett** » Wed Jan 07, 2009 8:00 am

To be certain, view the file outside of DataStage (say, with 'vi'), what do you see for that column? If it is bad there then your transformation is failing.