Reading xml file

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
shivan
Participant
Posts: 70
Joined: Mon Jul 25, 2005 9:29 am

Reading xml file

Post by shivan »

Hi All,
I am trying to read an xml file. The way it should read is like that:
If the column name is there in the tag and there is no value, then it should consider as an empty string.Where as if there is no column name in the tag, then the value should be taken as null. But in my case, when i am tryting to read the tag. There is an element missing in the tag. So it should put null value in it. But instead of null value there is an empty string there.
require assistance
thanks
shivan
WoMaWil
Participant
Posts: 482
Joined: Thu Mar 13, 2003 7:17 am
Location: Amsterdam

Post by WoMaWil »

Hi shivan,

first you should control if your target can make a difference between NULL and empty string by writing some test jobs.

If so, you are able thereafter to control the phenomen by code in your transformer-Stage.

Kind regards
Wolfgang
Post Reply