reading a delimited file

kumar_s · Post by **kumar_s** » Fri Mar 09, 2007 9:20 pm

But I dont find any reason, for not being read by the job as Char, if it all can do with decimal.

ady · Post by **ady** » Mon Mar 12, 2007 3:07 pm

I have the same problem with another file ...

its also a "|" delimited file coming from a sql script. I can see data from all the columns except one ... The column shows up blank, there is data present in the column for sure ...

The datatype is varchar... I tried changing it to decimal ( for some luck

), DIDNT WORK !!

Please suggest ..

kumar_s · Post by **kumar_s** » Mon Mar 12, 2007 9:17 pm

Does your source false under some different NLS collation?
Has you Datastage enabled with NLS?

ady · Post by **ady** » Tue Mar 13, 2007 7:51 am

I dont know if NLS ia enabled or not but, ... there are no characters other than alphabets and digits in the column thats missing

DSguru2B · Post by **DSguru2B** » Tue Mar 13, 2007 7:57 am

Send a few records to peek stage and see if the values show up in the log.