DSXchange

We have a requirement wherein we need to write messages into MQ in XML format using datastage.

Issue #1.One message(Xml file) will be corresponding to each store. Each message should have one header and the corresponding payload details(Items).
Currently the message is consolidated by Store,but instead of having one header and multiple detail,in each message , header is getting repeated for each detail record.

Issue#2. No WMQ Commit should be done until all messages for a store have been successfully put onto the message queue.
Can we commit all the messages at the end of the job?Either all the messages would get committed or none of them would be committed.
Let us know whether this would be feasible with MQ.

Can't help with Issue #2.

For Issue #1 - Did you figure out how to get the XML Output stage to create multiple files? On the Transformation Settings tab there are the Output Mode options - choose Use trigger column and select your Store number field to have it create a new file for each store.

The fact that your header repeats for each detail record sounds like you may not have set the repetition element properly. Or your XPath expressions aren't quite right. Did you generate the metadata for the output target from an xsd via the Manager or did you hand key it? Best to let DataStage generate it, in my experience.