Originally posted by: SystemAdmin

Hi,

working on a map , Input is a simple XML loop repeated e.g. 5000 times . The XML is converted to a flat file but customer only wants 1000 records at a time.

is there a why i can make the map to create 5 files of 1000 records each.

Input file layout:
<MAIN_LOOP>
<SUB_LOOP>
<DATA1>
..
..
<SUB_LOOP>
<DATA1>
..
..
..... 5000 times <SUB_LOOP> repeats.
Please help.

Thanks
Seth
#IBMSterlingTransformationExtender
#DataExchange
#IBM-Websphere-Transformation-Extender

Originally posted by: SystemAdmin

This isn't what I'd call a control break map. A CB map breaks on a value change of sorted input records. It's implemented by creating a Group and then inserting a component rule in the type tree of the form, Field2:$=Field2:$LAST

IAC, I believe one way is to create a batch group defined to contain 0:1000 records in the WTX type tree. Then loop on the group.

I don't recall how to this in an XML schema but it would have to be something similar.

I'm thinking there might also be a way to do something using EXTRACT, INDEX and a Counter variable.
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender
#DataExchange

Originally posted by: SystemAdmin

Thanks Jim, you are right it is not a control break issue. I tried with creating a map with 1:1000 but the map stops after 1000.

will post once i figure out
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender
#DataExchange

Originally posted by: SystemAdmin

File
Batch (1,s)
Record (1,1000)

An XSD will be slightly different but not much. Import the XSD to create a type tree and insert the Batch group.
#IBM-Websphere-Transformation-Extender
#IBMSterlingTransformationExtender
#DataExchange