i am trying to read a flatfile which is comma delimiter and double quoted. i have used the following format in SFS to read it.
first line column name-true
final delimiter-end
record delimiter-unix newline
field delimiter-comma
quote-double
i am working on DS 7.5.2 connected to unix server and my local OS is windows.
one more thing the file is having some special characters(chinese).its a .txt file. i can import the table definition only after taking the NLS map as unicode.
reading a flat file
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 53
- Joined: Fri Mar 07, 2008 1:17 am
reading a flat file
ETL DEVELOPER
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Welcome aboard. There will be an appropriate NLS map for Chinese (you neglected to mention whether it's traditional or simplified characters), which is probably the one you ought to be using. On a Windows server try MS950 (traditional) or MS936 (simplified) for starters.
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.