Welcome aboard. :D
That's not a question we can answer.
You have to know, or find out, how (that is, according to which standard) the data are encoded. That will indicate which NLS character map is appropriate to use.
NLS
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
NLS
The source is MainFrame GDG DataSet (FLAT FILE) that is encoded in EBCDIC. FTP Stage is being used to ready the data from the file. I have tried few other NLS map names that were installed on the system. None of these work for special characters.
However NLS map:ISO8859-1 works well if I do a Table to Table load.
Any suggestions/help would be appreciated.
However NLS map:ISO8859-1 works well if I do a Table to Table load.
Any suggestions/help would be appreciated.
ray.wurlod wrote:Welcome aboard. :D
That's not a question we can answer.
You have to know, or find out, how (that is, according to which standard) the data are encoded. That will indicate which NLS character map is appropriate to use.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
NLS / FTP
The only two options I have are Binary and ASCII for the FTP Stage --> Outputs Page --> Properties Tab --> Data Representation.
If I use Binary, it does not work. So I have used ASCII
How do i convert from EBCDIC to ASCII in FTP Stage, if possible??
If I use Binary, it does not work. So I have used ASCII
How do i convert from EBCDIC to ASCII in FTP Stage, if possible??
ray.wurlod wrote:Are you specifying that the FTP should convert from EBCDIC to ASCII ?