Search found 6 matches

by dsusercs
Mon Oct 29, 2018 1:19 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Use of Hierarchical Data XML Stage
Replies: 7
Views: 19664

Hi Ernie, Not really. I have pasted the XSD below. Have mapped the list <Document><BkToCstmrDbtCdtNtfctn><Ntfctn><Ntry><NtryDtls><TxDtls><RltdPties><UltmtDbtr><Id><OrgId><Othr> to O/P link. When I try to map the column <Document><BkToCstmrDbtCdtNtfctn><Ntfctn><Ntry><NtryDtls><TxDtls><RltdRmtInf><Rmt...
by dsusercs
Wed Oct 24, 2018 11:40 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Use of Hierarchical Data XML Stage
Replies: 7
Views: 19664

Hi Ernie, This is where the trick comes in, with Hierarchical Stage. When XSD says, for e.g. if "departments" is maxOccurs="unbounded" minOccurs="0" then, departments get classified as a "list" even though it is a nested child of company. The moment it is defi...
by dsusercs
Tue Oct 23, 2018 10:30 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Use of Hierarchical Data XML Stage
Replies: 7
Views: 19664

Hi eostic, The goal now is to have the complete dump of the XML file for later business and reporting/data needs. But most of the tags are currently empty with a bunch of optional tags not being present at all, but may contain data later in the phase of the project. About the size of the file, we no...
by dsusercs
Sun Oct 21, 2018 11:43 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Use of Hierarchical Data XML Stage
Replies: 7
Views: 19664

Use of Hierarchical Data XML Stage

Hi, I'm not sure if I understand the Hierarchial Data XML stage right. I have gone through the Red Books and understand that a list can only be mapped with another list. I also see that a list can be created only when a link is created. My job design: Hierarchial Data -> Merge -> Sequential file I h...
by dsusercs
Fri Jun 22, 2018 1:20 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Not able to map list in the same level in Hierarchial Stage
Replies: 0
Views: 1845

Not able to map list in the same level in Hierarchial Stage

All, I have a problem for which my search in Internet didn't yield any posts. I'm sure that this might have been already solved by somebody and may be I'm making a very small mistake. I have an xml from which I have to create a text file and I'm using Hierarchial Stage to do this. I have an XML of t...
by dsusercs
Mon Aug 29, 2016 5:03 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Wrapper Stage not giving any output
Replies: 0
Views: 1831

Wrapper Stage not giving any output

Hello, We have a requirement where DS job should call a simple linux script which will take a single value as input and gives back another single value as output. I would like to call this script using wrapper stage. Source is a sequential fiel with 10 records and each reocrd has a single value for ...