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
p.thier1
Participant
Posts: 10 Joined: Wed Jun 09, 2004 7:26 am
Post
by p.thier1 » Mon Jun 13, 2005 3:05 am
I have a very simple job
SEQ FILE ----> TRANSFORMER -----> XML File
In my sequential file, I have a certain number of columns
Some of them could have the NULL value
When I generate the XML file, Tags are not appearing in my
XML file when the DATA is NULL
I want to see the TAG in my XML result File altough the data is null
I think the option #PCDATA in the Description file is not
the good one to see the tag
Could you please give me any informations (or answer)
to solve my problem
Thanks a lot
WoMaWil
Participant
Posts: 482 Joined: Thu Mar 13, 2003 7:17 am
Location: Amsterdam
Post
by WoMaWil » Mon Jun 13, 2005 3:13 am
what do you use to see the xml-output?
(a) an normal text editor
(b) an xml-viewer (like internet explorer)
p.thier1
Participant
Posts: 10 Joined: Wed Jun 09, 2004 7:26 am
Post
by p.thier1 » Mon Jun 13, 2005 3:16 am
I just double click on it
(internet explorer is launched)
WoMaWil
Participant
Posts: 482 Joined: Thu Mar 13, 2003 7:17 am
Location: Amsterdam
Post
by WoMaWil » Mon Jun 13, 2005 3:19 am
Better you use notepad.
You might blame DataStage.
I wrote some month ago a vba-Job for xml and made the expirience, that the internet explorer was the one who showed the null without the tag.
Kind regards
Wolfgang
p.thier1
Participant
Posts: 10 Joined: Wed Jun 09, 2004 7:26 am
Post
by p.thier1 » Mon Jun 13, 2005 3:25 am
OK but when I edit it witk notepad, the result is exactly the
same.
Do you mean that my problem can't be solved ?
Patrick