DSXchange: DataStage and IBM Websphere Data Integration Forum
View next topic
View previous topic
Add To Favorites
This topic has been marked "Resolved."
Author Message
sainath



Group memberships:
Premium Members

Joined: 19 Nov 2004
Posts: 136

Points: 1234

Post Posted: Mon Dec 17, 2018 2:47 pm Reply with quote    Back to top    

DataStage® Release: 11x
Job Type: Parallel
OS: Unix
Hi
1) I want to omit null tags inside the xml group
I made column nullable and selected omit null tag option inside inside hierarchy stage. But I still see null tags. Please let me know how to fix this issue.
2) is there any may to remove duplicates in XML file before generating.


Thks
sainath



Group memberships:
Premium Members

Joined: 19 Nov 2004
Posts: 136

Points: 1234

Post Posted: Mon Dec 17, 2018 6:44 pm Reply with quote    Back to top    

Hi

In following example the POLICY_CLAUSE_TYPE_CODE/> is in xml group which is repeated many times with null values because other xml group has distinct values.can you please let me know where in the stage to specify that so that the xml tags not repeated with same data.


Code:
-<PolicyClausesDetails>
<POLICY_CLAUSE_TYPE_CODE/>

</PolicyClausesDetails>

-<PolicyClausesDetails>
<POLICY_CLAUSE_TYPE_CODE/>
</PolicyClausesDetails>

-<PolicyClausesDetails>
<POLICY_CLAUSE_TYPE_CODE/>
</PolicyClausesDetails>

-<PolicyClausesDetails>
<POLICY_CLAUSE_TYPE_CODE/>
</PolicyClausesDetails>

-<PolicyClausesDetails>
<POLICY_CLAUSE_TYPE_CODE/>
</PolicyClausesDetails>
Rate this response:  
Not yet rated
Display posts from previous:       

Add To Favorites
View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours