DSXchange

Hello Friends, Have a Wave job which creates output xml and write to target Queue. For this used XML parser/composer stage and DTS. Job has parameters defined for Message Expiry and Persistance and these paramters mapped in XML stage to the DTS stage columns EXPIRY, PERSISTENT (Q properties). The jo...

Thanks ArnDW.. But in some of projects have 100 jobs with MQ Connector stage and each will different MessageRead mode. The export takes much time.. Also the MessageRead Mode is not coming as xml tag. Its is coming as CDATA.. 'SED' command may work, Please let me know how can relate Job and respectiv...

Hello All, I have requirement to identify list of jobs with MQ Connector stage and in that get Message Read Mode (Keep/Delete/...) and Execution Mode property values Please provide query or any quicker way to get this instead of checking manually. To get list of jobs , I have used option "Where...

Thank you. Its working fine...

Hi, I have requirement to keep mesages that are failed to process in queue and messages processed successfully has to load to database and should be deleted from Queue. I am using MQ Connector as Source and Distributed transaction stage to load processed messages to DB2 table. If I have 5 messages i...

To flush the queue, do we require another job? Flush means reading Queue again with Delete option or any other option available? Can't we achive the same in single job

Hello All, I have the requirement to read xml messages from Queue and apply transformations like mandatory checks, rejection and load data to database. I have selected the Delete (Under Transaction) option in MQ read stage. The messages are deleted from queue if job aborted in intermediate stages li...

Hi

Set the MQ stage properties
MessagingWriteMode = "Create"
RecordCount=0
RowBufferCount=-1