Parsing of XML file into flat file through sort jcl

ibmbansal08 · New User Joined: 31 Jul 2012 Posts: 6 Location: India

Hi,

Please help me in solving this problem.

My I/P XML file (RECFM is VB) is :
- <cost type="I" xsi:type="costElementType">
<country>DE</country>
<onshore>true</onshore>
<startdate>2010-10-22</startdate>
<enddate>2015-12-31</enddate>
<offeringname>01K0059</offeringname>
<costvalue uom="USD">130.23</costvalue>
<pricetype>PUR</pricetype>
<costtype>LDP</costtype>
</cost>
- <cost type="I" xsi:type="costElementType">
<country>DE</country>
<onshore>true</onshore>
<startdate>2000-01-02</startdate>
<enddate>2007-12-31</enddate>
<offeringname>8660</offeringname>
<varianttype>FEA</varianttype>
<variantname>A043</variantname>
<costvalue uom="EUR">130.23</costvalue>
<costtype>LDP</costtype>
</cost>

I want the FB output file of LRECL 103 as :

DE true 2010-10-22 2015-12-31 01K0059 USD 130.23 PUR LDP
DE true 2000-01-02 2007-12-31 8660 FEA A043 EUR 130.23 LDP

Nic Clouston · Posted: Mon Oct 08, 2012 7:53 pm

2 months ago you were asking almost the same question? Can you not adapt that solution to your present requirement?

enrico-sorichetti · Posted: Mon Oct 08, 2012 7:53 pm

why don' You ask Your IBM colleagues ?

Nic Clouston · Posted: Mon Oct 08, 2012 7:56 pm

If you really do work for IBM then you have all the help you need within the company. After all, it is IBM's product. All you have to do, at worst, is drop Kolusu an email internally.

enrico-sorichetti · Posted: Mon Oct 08, 2012 8:01 pm

yes he does..
see the comments to the TS previous topics

and Frank Yaeger confirmed some time ago in a private email exchange
that IBM employees are not supposed ( by IBM policy and conduct guidelines)
to ask for help on public forums and should use the IBM Internal resources

Nic Clouston · Posted: Mon Oct 08, 2012 10:45 pm

Perhaps, then, the topic should be locked and TS's privileges restricted so that he cannot start a topic.