Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.
Moderators: chulett , rschirm , roy
aneesh5142
Premium Member
Posts: 15 Joined: Wed Feb 11, 2009 11:41 am
Location: Chennai
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.
IBM-DS
chulett
Charter Member
Posts: 43085 Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO
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?
-craig
"You can never have too many knives" -- Logan Nine Fingers
aneesh5142
Premium Member
Posts: 15 Joined: Wed Feb 11, 2009 11:41 am
Location: Chennai
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.
IBM-DS
priyadarshikunal
Premium Member
Posts: 1735 Joined: Thu Mar 01, 2007 5:44 am
Location: Troy, MI
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.
Priyadarshi Kunal
Genius may have its limitations, but stupidity is not thus handicapped.
chulett
Charter Member
Posts: 43085 Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO
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.
-craig
"You can never have too many knives" -- Logan Nine Fingers