How to UTF-8 data into EBCDIC or ASCII form through paraller

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
Vijay Kumar
Participant
Posts: 59
Joined: Sat May 29, 2004 12:31 am
Location: Pune

How to UTF-8 data into EBCDIC or ASCII form through paraller

Post by Vijay Kumar »

Hi,

I am using parallel extender v7, on Unix machine.

How do we accept the UTF-8 data through parallel extender, so that it get
convert into EBCDIC or ASCII form.

Thanks & Regards,

Vijay
Eric
Participant
Posts: 254
Joined: Mon Sep 29, 2003 4:35 am

Post by Eric »

Install DataStage with NLS enabled.

You can then set the MAP that you read your data (i.e. UTF)
and you can set the MAP to use to write the data. (i.e. EBCDIC)

The sequential file stage also has some special options for reading EBCDIC data.
premreddyb
Participant
Posts: 6
Joined: Thu Jun 10, 2004 3:32 pm

Post by premreddyb »

Hi,

I tried using NLS with my Input file UTF8 having japanese Cahraters. In the ouput the japneses characters are replaced by "?" .

Please suggest if you can overcome with that problem using NLS. please mail me if you any examples.

Regards,
Prem

Eric wrote:Install DataStage with NLS enabled.

You can then set the MAP that you read your data (i.e. UTF)
and you can set the MAP to use to write the data. (i.e. EBCDIC)

The sequential file stage also has some special options for reading EBCDIC data.
Eric
Participant
Posts: 254
Joined: Mon Sep 29, 2003 4:35 am

Post by Eric »

You see a "?" normally due to a mapping/locale mismatch. I suggest you read the DataStage NLS guide and check the maps and locales that you are using against those you expect in your datafile.
premreddyb
Participant
Posts: 6
Joined: Thu Jun 10, 2004 3:32 pm

Post by premreddyb »

Hi Eric,

I have a sequentilfile which contains filed 7 to filed 11 contians Japanses characters. Could you please help me how to convert it to EBCDIC and then after applying few busienss rules I ahve to write it back to Japnese charcters to laod into some other database.

Regards,
Prem
Eric wrote:You see a "?" normally due to a mapping/locale mismatch. I suggest you read the DataStage NLS guide and check the maps and locales that you are using against those you expect in your datafile.
Post Reply