Hi all,
I have a requirement to split xml file into different files based on condition .
The HEADER and INFORMATION should be there in all files along with the condition.
Input file:-
<?xml version="1.0" encoding="UTF-8"?>
<TRANSACTION>
<HEADER>
<NAME>ALEX</NAME>
</HEADER>
<INFORMATION>
<LASTNAME>CRISTOPER</CRISTOPER>
</INFORMATION>
<RESIDENCE>
<PLACE>DENMARK</PLACE>
</RESIDENCE>
<NUMBER>
<LOCAL>123456789</LOCAL>
</NUMBER>
<TRANSACTION>
Expected Output:-
File1:-
condition:: (if 8,7,ch,eq,c'DENMARK')
<?xml version="1.0" encoding="UTF-8"?>
<TRANSACTION>
<HEADER>
<NAME>ALEX</NAME>
</HEADER>
<INFORMATION>
<LASTNAME>CRISTOPER</CRISTOPER>
</INFORMATION>
<RESIDENCE>
<PLACE>DENMARK</PLACE>
<RESIDENCE>
File2:-
condition:: (if 8,9,eq,ch,c'12346789')
<?xml version="1.0" encoding="UTF-8"?>
<TRANSACTION>
<HEADER>
<NAME>ALEX</NAME>
</HEADER>
<INFORMATION>
<LASTNAME>CRISTOPER</CRISTOPER>
</INFORMATION>
<NUMBER>
<LOCAL>123456789</LOCAL>
</NUMBER>
i have tried using WHEN=GROUP option:-
INREC IFTHEN=(WHEN=GROUP,
BEGIN=(8,7,CH,EQ,C'DENMARK'),PUSH=(81:8,7)),
IFTHEN=(WHEN=GROUP,
BEGIN=(8,9,CH,EQ,C'123456789'),PUSH=(81:8,9))
OPTION COPY
But not able to proceed further.
Can anyone please help me out with this.
Thanks.