Page 2 of 2
Posted: Fri Mar 09, 2007 9:20 pm
by kumar_s
But I dont find any reason, for not being read by the job as Char, if it all can do with decimal.
Posted: Mon Mar 12, 2007 3:07 pm
by ady
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
![Wink :wink:](./images/smilies/icon_wink.gif)
), DIDNT WORK !!
Please suggest ..
Posted: Mon Mar 12, 2007 9:17 pm
by kumar_s
Does your source false under some different NLS collation?
Has you Datastage enabled with NLS?
Posted: Tue Mar 13, 2007 7:51 am
by ady
I dont know if NLS ia enabled or not but, ... there are no characters other than alphabets and digits in the column thats missing
Posted: Tue Mar 13, 2007 7:57 am
by DSguru2B
Send a few records to peek stage and see if the values show up in the log.