EBCIDIC to ASCII Conversion
Posted: Wed Jun 29, 2016 2:13 pm
Hi,
I'm using Character Set as "EBCIDIC" in seq file stage, nls as UTF-8. It is reading the ! in mainframe ebcidic file as ] character. I checked in below site that datastage import/export operator converts ! as ].
https://www.ibm.com/support/knowledgece ... ities.html
Is there any other way of reading this as ! symbol itself in datastage. I got the update from mainframe team as they are using CCSID 037. I tried dd command, and that is also converting to ] symbol. I tried changing NLS setting IBM037, ASCL_MS1252 but not working.
I got lots of jobs. If I need to do this transformer stage then I need to apply this transformation in all the columns and in all the jobs.
I'm using Character Set as "EBCIDIC" in seq file stage, nls as UTF-8. It is reading the ! in mainframe ebcidic file as ] character. I checked in below site that datastage import/export operator converts ! as ].
https://www.ibm.com/support/knowledgece ... ities.html
Is there any other way of reading this as ! symbol itself in datastage. I got the update from mainframe team as they are using CCSID 037. I tried dd command, and that is also converting to ] symbol. I tried changing NLS setting IBM037, ASCL_MS1252 but not working.
I got lots of jobs. If I need to do this transformer stage then I need to apply this transformation in all the columns and in all the jobs.