Read sequential file encoded with WE8DEC / DEC-MCS
Posted: Fri Sep 20, 2013 1:13 pm
I need to load a sequential file that is encoded with character set WE8DEC, but I don't see that listed in the available maps on the NLS tab of the sequential stage properties.
I've found out that WE8DEC is the same as DEC-MCS. I did some research and found that ISO-8859-1 is very similar, but differs in 3 printable character positions and 15 others that are undefined in DEC-MCS.
Does anyone know if one of the other DataStage maps are equivalent to WE8DEC (DEC-MCS)?
FYI - The source of the sequential file is and older verion of SAP/BW that is NOT enabled for Unicode. The SAP techs told me that BW sits on Oracle database with NLS_LANG set to WE8DEC and that Open Hub will write files in Raw or binary mode. That is why I believe the file is DEC-MCS encoded. I can't tell just by looking at it.
I've found out that WE8DEC is the same as DEC-MCS. I did some research and found that ISO-8859-1 is very similar, but differs in 3 printable character positions and 15 others that are undefined in DEC-MCS.
Does anyone know if one of the other DataStage maps are equivalent to WE8DEC (DEC-MCS)?
FYI - The source of the sequential file is and older verion of SAP/BW that is NOT enabled for Unicode. The SAP techs told me that BW sits on Oracle database with NLS_LANG set to WE8DEC and that Open Hub will write files in Raw or binary mode. That is why I believe the file is DEC-MCS encoded. I can't tell just by looking at it.