hello all,
I am reading a Mainframe file thru Sequential file stage . The Format of the sequential file is specified as .. Charcater Set is EBCIDIC and the data format is Binary. I am reading a Char(40) or PIC X(40) field and strangely all the exclamation '!' characters on the Mainframe are being translated as Right Bracket ']' characters..
Example:
Source Data is 'Hello !' in the Mainframe
It is being Read as 'Hello ]' in Datastage..
Does anyone have any idea whats going on ??
Thanks..
Sequential File Reading Mainframe data
Moderators: chulett, rschirm, roy
-
- Charter Member
- Posts: 38
- Joined: Wed Mar 17, 2004 1:16 am
- Location: USA
-
- Participant
- Posts: 3593
- Joined: Thu Jan 23, 2003 5:25 pm
- Location: Australia, Melbourne
- Contact:
Have you tried using the Complex Flat File stage? It has support for text/Binary formats and ASCII/EBCDIC formats.
Certus Solutions
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn:Vincent McBurney LinkedIn
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn:Vincent McBurney LinkedIn
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Do you have NLS enabled and, if so, what client character map are you using?
It seems odd that "Hello" is being converted accurately but "!" is not. Are you sure it's really "!"? (Check with a hex editor both in the EBCDIC source and the ASCII target.) Could be a strange problem with the data browser; what output do you get in a text file?
It seems odd that "Hello" is being converted accurately but "!" is not. Are you sure it's really "!"? (Check with a hex editor both in the EBCDIC source and the ASCII target.) Could be a strange problem with the data browser; what output do you get in a text file?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
I have encountered similar case too, it is not "!", but ">".
What 's worse is it didn't convert to another character, but lead to incorrect mapping
NLS was enabled, with "Project default (ISO-8859-1)" in client.
What 's worse is it didn't convert to another character, but lead to incorrect mapping
NLS was enabled, with "Project default (ISO-8859-1)" in client.
ray.wurlod wrote:Do you have NLS enabled and, if so, what client character map are you using?
It seems odd that "Hello" is being converted accurately but "!" is not. Are you sure it's really "!"? (Check with a hex editor both in the EBCDIC source and the ASCII target.) Could be a strange problem with the data browser; what output do you get in a text file?
-
- Charter Member
- Posts: 38
- Joined: Wed Mar 17, 2004 1:16 am
- Location: USA
ray,ray.wurlod wrote:Do you have NLS enabled and, if so, what client character map are you using?
It seems odd that "Hello" is being converted accurately but "!" is not. Are you sure it's really "!"? (Check with a hex editor both in the EBCDIC source and the ASCII target.) Could be a strange problem with the data browser; what output do you get in a text file?
I have checked the EBCIDIC source and it is a '!' . When i write this data to a Text file. its again converted to ']' charcater.
I do not have admin privilages..how else can i check weather NLS is enabled and about which Char Map i am using ??
Thanks in advance...
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Charter Member
- Posts: 38
- Joined: Wed Mar 17, 2004 1:16 am
- Location: USA