Creating file in Unicode

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
mydsworld
Participant
Posts: 321
Joined: Thu Sep 07, 2006 3:55 am

Creating file in Unicode

Post by mydsworld »

I am trying to generate a flat file in Unicode format.I made the following change in the Sequential file stage.

1. Set NLS Code page : UTF-16
2. Set char/varchar column extended property 'Unicode'.

But the file is generated with strange characters like this (when I view in Notepad)
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Like... what?
-craig

"You can never have too many knives" -- Logan Nine Fingers
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

I think 'strange characters' are allowed under UniCode. What are the hex values? Use a (free) hex editor or 'od -h' on the UNIX side to find out. What kind of data are you encoding?
-craig

"You can never have too many knives" -- Logan Nine Fingers
mydsworld
Participant
Posts: 321
Joined: Thu Sep 07, 2006 3:55 am

Post by mydsworld »

The problem is that I need to use the file as SAP BAPI Input and those strange characters are not accepted in BAPI stage.However BAPI stage expects input file in Unicode.
Post Reply