Loosing Fields when ">" in string

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
odesia
Premium Member
Premium Member
Posts: 3
Joined: Tue Jun 12, 2007 10:18 am
Location: Montreal
Contact:

Loosing Fields when ">" in string

Post by odesia »

Hi,

I have a problem with the Greater Than sign ">" when reading a char field from
a sequential file or a database (same result in both cases).

When there is a space immediatly following the ">" sign, every field before plus the beginning of
the field where that sign is located up to after the space are lost...


Source:

Field1 Field2
------ ------

"000511" "Rate1 -> Rate2"


Result:

Field1 Field2
------ ------

"Rate2"


If I remove the space everything is o.k. but I don't want to
apply that solution because there may be other weird characters
and I want to find out why...

We're using version 7.1r2 of DataStage PX and our project's default NLS Map is ISO-8859-1


Any help will be appreciated,


Chris
Post Reply