I've an issue in retrieval of data from sequential file

aneesh5142 · Post by **aneesh5142** » Thu Sep 25, 2014 7:21 am

I've an issue in retrieval of data from sequential file . Characters hyphen '-' is loaded as inverted question mark.

Job structure is reading data from sequential file and loads in to oracle table.

While viewing data in sequential file hyphen '-' is viewed as inverted question mark.

what kind of encoding I need to use to fix this.

chulett · Post by **chulett** » Thu Sep 25, 2014 7:50 am

Then it's not a standard hyphen but probably one of those "smart" ones from something like Word. What is its ASCII value?

aneesh5142 · Post by **aneesh5142** » Thu Sep 25, 2014 11:35 pm

Thank you for the response.

I think the special character is not hyphen it is longer than hyphen.
I am not able to find the ASCII value of that.
Can you please guide me to get that.

priyadarshikunal · Post by **priyadarshikunal** » Fri Sep 26, 2014 3:00 am

Try any hex editor to see its hex value. Else you can Isolate that in datastage job and use seq() function to get its ascii value.

chulett · Post by **chulett** » Fri Sep 26, 2014 6:58 am

Or on a UNIX system use "od" (Octal Dump) to dump the file in various flavors to see what each character is. For example, od -h will dump it in hexadecimal.