MQSeries.net :: View topic - Conversion Mapping from WMB 6.1 to WMB 8.0

petersonvz · Posted: Wed May 22, 2013 1:30 am Post subject:

Dear All

Please, I need help to resolve an error to Conversion Mappings (". Msgmap" for. "Map"). I'm doing a migration from WMB 6.1 to WMB 8.0.

The function "FOR" is used, in the WMB 6.1, when there is a repetition in a XML File, and each repetition in the XML record is linked to a particular type of register in a sequential file.

For Example:
I have the following sequential file:
-----------------------------------
00FileNameXXX2013-05-21 HEADER
1020130521000012013-05-21 DETAIL
1020130521000022013-05-20 DETAIL
1020130521000032013-05-19 DETAIL
-----------------------------------

--------------------------------------------------
COBOL RECORD DEFINITION (Just for demonstration):

01 FILE REGISTER PIC X(....)
05 RECORD-TYPE PIC X(0002)
01 HEADER-REG.
05 FILLER PIC X(0002)
05 FILE-NAME PIC X(....)
05 CREATION-DATE PIC X(....)
01 DETAIL-REG.
05 FILLER PIC X(0002)
05 OPERATION-NUMBER PIC X(....)
05 PAYMENT-DATE PIC X(....)
--------------------------------------------------

The first two positions indicates the record Type (In this case: 00 - Header and 10 - Detail)
The Header record contains information about the XML file (Ex: File name, Creation Date ...)
Each Detail Record indicates a repetition in XML Group "<GroupDetail>" (Operation Number, and payment Date)

After mapping, follows the XML file:

<?xml version="1.0" encoding="utf-8" ?>
<STCDOC xmlns:ast=>
<Header>
<FileName>FileNameXXX</FileName>
<CreationDate>2013-05-21</CreationDate>
</Header>
<Detail>
<ASTC004>
<Repetition>
<GroupDetail>
<OpNumber>2013052100001</OpNumber>
<PaymentDate>2013-05-20</PaymentDate>
</GroupDetail>
<GroupDetail>
<OpNumber>2013052100001</OpNumber>
<PaymentDate>2013-05-20</PaymentDate>
</GroupDetail>
</Repetition>
</ASTC004>
</Detail>
</ast:STCDOC>

In this case the Message Broker Mapping (Version 6.1), uses the function "FOR" about the records that are of type "10" in the Sequential file, and while exists these types of record, the Broker processes them until the end of file, generating repetitions in XML file <GroupDetail>.

Mapping (From Message Broker 6.1):

....
Map Script | Value
.....

GroupDetail
FOR | $source/DETAIL-REG/Data
OperationNumber | $source/DETAIL-REG/Data/REG10/OPERATION-NUMBER
PaymentDate | $source/DETAIL-REG/Data/REG10/PAYMENT-DATE

.....

After conversion, using the Conversion Tool in the Message Broker Toolkit 8.0.0: â€œConvert Message Map from .msgmap to .mapâ€.
Generated the following error message:
- A map transform has more than one output. Remove all except one output from de transform to resolve the problem.
- The For each transformation must have one, and only one, output.

I Can't Find the Funcition "FOR" used in version 6.1, in Message Broker Toolkit 8.0.0.0.
* This means that this function is no longer available?
* Is there any other feature or function to be used to resolve this issue?
* What changes are needed in this case?
* How to transform many records in a sequential file in groups in the XML File, using WMB8.0?

Thank you !!!

Best Regards,
Peterson Zambiassi