Originally posted by: Kepa_Screen

Hi!

I'm using WSTX 8.1.0.3, on Aix box.
One of our maps gets data from an Oracle AQ using it's adapter.

This queue need to dequeue registers using a priority field at the header, in order to extract records in the queue first if they have more priority than other records at the queue. This is indicated at oracle db level, when the queue is created using pl-sql commands, this considerations are explicied, what fields have to be the priority ( by date, by numerical sequence, and the most important ...priority ).

The dequeue is FIFO normally, all records with priority field at header = 5, but this can be altered, if we put some records with priorty field = 2 these are extracted first of all ...and between them, the order is based on some other fields ( sequential number, date&time ... )

All works well when dequeued the records using the pl-sql commands, but this is not working when dequeued by a Wstx Map using Oracle AQ adapter because this supoused order is not being respected and the dequeue always is done without any priority...only FIFO ( first in -> fist out )

So, OracleAQ adapter behaviour could be modified ?

Is there some option at some configuration file for the adapter for changing this ?

Thank you very much in advance.
#DataExchange
#IBM-Websphere-Transformation-Extender
#IBMSterlingTransformationExtender

Originally posted by: Kepa_Screen

More Updates:

We have been looking at the documentation for Oracle AQ at WSTX, and we saw that there is a -P ( priority command ) that can be used to change the priority of a record in a queue, but this command only stands for Target, and not for source ( this is our case ).

So, we know that working with oracle pl-sql commands ( dbms_queue.dequeue ) our process is working well, but not if the dequeue is done by a map, using oracleAQ adapter...

We think that there must be some option that we may use at GET command, or at configuration files for adapters that can do what we need...GET records from queue first if the priority of those is bigger than some other records at the same queue, but..don't know where to explicy this.

Could anyone give us some light about this ?

Thank you very much in advance.
#IBMSterlingTransformationExtender
#DataExchange
#IBM-Websphere-Transformation-Extender