DSXchange

Thanks Ernie,

I got the option on PLUG-IN stage for selecting PUTTIME and PUTDATE that solved my problem.

Hi All, I am trying to delete the MQ messages based on a combination of PUT TIME and PUT DATE. Is it possible? As per options that are available 1) Delete 2) Delete (Under Transaction) These two options will not work out to select the date and time stamp based for selecting the messages. Is there an...

Ernie,

Thanks and Final Question: Did you see any problem in future if i run the message through xml output instead xml input.

Ernie, Thanks for the response. Yes at the begining i was flowing MQ message to xml input directly. Very beginging it was like the following. MQ-->Transformer-->xml inut-->sequential file. But after your suggestion i took out the xml input stage and tried to put directly into the seq file. MQ-->Tran...

Due to many new lines and carriage returns sequential file is unable to read it or store it as a single record. same case with the xml input stage too. As for as MQ it is still treating them as a one message. but once the message is extracted from the MQ the message is divided into many lines. Final...

Still the depth of queue is showing the correct number of messages. Now i am not sure exactly where the splitting is occuring.

If i want to remove these line splits after the sequential file load How can i do it.

Thanks.

I did a small test of taking a big xml with a single line format and put it in queue my self and read it from job. works fine and the unix shows as record count 1.

It was the same message that got splitted when i am reading it from MQ (with other messages)

Ernie, Took the XML out of the job. Right now i have only MQ stage --> transformer--> sequential file. For a small message i am able to receive in single line. for big messages like over 9999 bytes it is splitting into many lines. As of now i have a single payload column specified as long varchar wi...

Hi Ernie, yes i have a single column with longvarchar data type with no length mentioned. I have the $APT_DEFAULT_TRANSPORT_BLOCK_SIZE=999999 defined, running on a single node. MQ-->xml-->sequential file (Performance statistics shows same number of records.) I did ignored CRLFs still not able to und...

Hi All, I am trying to read mq messages (xml messages) and parse them through the xml input stage and store them in a text file. I am able to read it from MQ stage but after reading the messages they are not in a single line. The whole message is splitted into many lines (still its a valid xml recor...

Ernie,

Yes. DS is 8.1 with FP1 Applied. As you said i did resorted and removed the namespace details and ran it. It is working fine. But if include namespace statment in my xml as well as in my inputstage it is not working.

Thanks.

Hi All, I am having trouble with namespace declaration. Job is not showing the data If i inlcude namespace. Xml: <?xml version="1.0" encoding="UTF-8"?> <Level1 xmlns="http://www.some.com/xmlns/one/Level1"> NameSpace declarations: xmlns:soapenc="http://schemas.xmlso...

Thanks throbinson,

Acutually it is working. I have added only parameter like

/#Jpass1#/Col1/text()

and passed differnt xmls as parameter values to get same column information from different xmls.

Thanks.

Hi All, I am trying to capture couple of column data that are same in the 3 different xmls by dynamically changing the xpath expressions. for ex: col1,col2,col3---------xml1,xml2,xml3 is there any way to pass xpath expressions dynamically when i run my job atleast first part like (/xml1/col1/text() ...

Hi All, I was trying to read messages from one QUEUE and divert them to many Queues using MQ stage/Connector and i tried to follow the below mentioned link. http://www.dsxchange.com/viewtopic.php?p=267652&sid=adf22c9eb10a30c4be167fa46699213b Job: Mq---Transformer---MQ 1)Every time my job runs th...