View previous topic :: View next topic
|
Author |
Message |
useit
Active User
Joined: 05 Oct 2006 Posts: 152
|
|
|
|
hi,
can we split the XML records using DFSORT??.
say for example .
i have input file (FB,LRECL=32760).
a single line can contain multiple XMLS.
ex:
<?xml version="1.0" encoding="utf-8"?><xmldata1><?xml version="1.0" encoding="utf-8"?><xmldata2><?xml version="1.0" encoding="utf-8"?><xmldat3>
in the above example we have 3 xmls records in the same line. can we split this record into 3 single records??
my output should be:
<?xml version="1.0" encoding="utf-8"?><xmldata1>
<?xml version="1.0" encoding="utf-8"?><xmldata2>
<?xml version="1.0" encoding="utf-8"?><xmldata3>
Regds,
useit |
|
Back to top |
|
|
Bill Woodger
Moderator Emeritus
Joined: 09 Mar 2011 Posts: 7309 Location: Inside the Matrix
|
|
|
|
What level of DFSORT do you have? How many is the maximum number of xml elements you can have on one record?
I suspect you'd be better off with something which can parse xml directly. |
|
Back to top |
|
|
useit
Active User
Joined: 05 Oct 2006 Posts: 152
|
|
|
|
bill.
DFSORT version leve is VERSION 1.12.
The record length of the input XML dataset can be any value up to 32760.
Regds,
useit |
|
Back to top |
|
|
Bill Woodger
Moderator Emeritus
Joined: 09 Mar 2011 Posts: 7309 Location: Inside the Matrix
|
|
|
|
You have said how many bytes are in a record already. I was wondering how many xml elements there may be on a record.
With your level of DFSORT, you only have 100 parsed fields available (2.1 has 1,000).
With 32760 bytes, you will easily have more than 100 elements potentially present. Possible that you have more than 1000.
Using 1000 parsed fields, or even 100, would be a lot of code.
Why do you want to split it up anyway? |
|
Back to top |
|
|
useit
Active User
Joined: 05 Oct 2006 Posts: 152
|
|
|
|
i have built a COBOL test driver for DB2 stored procedures which use XML to pass data(common for all stored proc).in order to process as many input XML I wanted to split the record and read one by one until end of i put. |
|
Back to top |
|
|
|