IBM Mainframe Forum

hi
I need some help. through xmlgen I have created a xml file which looks like this
<?xml version="1.0"?>
<FILE DSN="XXXXXXXXX">
<ksingh RECORD="00001">
<AA>2008</AA>
<BB>LL</BB>
<CC>002</CC>
<DD>03</DD>
<ksingh>
<ksingh RECORD="00001">
<AA>2009</AA>
<BB>EL</BB>
<CC>001</CC>
<DD>04</DD>
<ksingh>

I want to convert it to something like this
2008,LL,002,03
2009,EL,001,04

please help me on this one. thanks a lot

You cannot do this using JCL - although you may need JCL to execute the program that will do this. So - are you wanting to write a program (which language) or see if there is a utility program that can be utilised to do this for you?

I can write a program in java or perl to do so
I was just curious if there is some jcl or utility program to do it.
this xml was created from flat file using xmlgen so I thought may be there is some way to reverse it

The PL/1 and COBOL languages both ahve XML facilities. IT is possible that the sort utilities could extract the data you want. I will move to DFSort and maybe someone there will be able to give you clues as to how to go about it.

These users thanked the author NicC for the post:

k singh (Fri Jan 30, 2015 2:28 am)