SEQ FILE to 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
p.thier1
Participant
Posts: 10
Joined: Wed Jun 09, 2004 7:26 am

SEQ FILE to XML file

Post by p.thier1 »

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 »

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 »

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 »

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 »

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
Post Reply