DSXchange

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.

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

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.

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.

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.