Hi Padres,
I was debugging a simliar issue for my resource who was working on a similar Integration Scenario.
The reason why your map is not getting executed is
1. The xml file from the DB2 Receive Adapter doesnot comply with the Input Schema.
So the Map fails and it passes the xml to SQL.
How to test it?
1.Receive the file from the DB2 Receive Adapter and drop it in a File Folder without mapping it.
2.Test the map manually using this file as input,it will not succeed.
The issue might be with the prefix “ns0” in the incoming xml file.
Solution:
Use a custom receive pipeline and add the prefix “ns0” to the file.
It should help you.