Destructive Reading of selective messages from Datastage MQ

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
basav_ds
Participant
Posts: 24
Joined: Sun Nov 11, 2007 11:19 pm
Location: Mumbai

Destructive Reading of selective messages from Datastage MQ

Post by basav_ds »

I am having many XML messages on i/p Queue. The sample XML data format is as shown below:
<xml>
<order Type="SOH">
<Typenumber>"100"</Typenumber>
<order_date>"03-11-2007"</order_date>

</order>
</xml>

Each of the messages have attribute value Type="SOH" or "SOL" etc.
Depending on the value of the attribute Type, we want to read only those messages having specific attribute value(say Type="SOH")
from the Queue and delete only those messages from the Queue which are read,
keeping the unread messages(Those having value of attribute Type <> "SOH") intact on the Queue.

Is this Selective Destructive Read is possible?

Please suggest if there is any solution to this.
I never let school to interfere in my education
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Selective destructive read is not possible. However, there's nothing to prevent you from writing only the required-to-be-kept messages into another (temporary) queue.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply