reading a flat file

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
datastagedw
Participant
Posts: 53
Joined: Fri Mar 07, 2008 1:17 am

reading a flat file

Post by datastagedw »

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.
ETL DEVELOPER
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

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.
Post Reply