MQSeries.net :: View topic - TDS Outbound Generation

MQSeries.net

Tech Exchange

Education

Certifications

Library

Info Center

SupportPacs

FAQÂ Â

Usergroups

RSS Feed - WebSphere MQ Support

RSS Feed - Message Broker Support

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » TDS Outbound Generation - Require Quotes and Delimiters

TDS Outbound Generation - Require Quotes and Delimiters

« View previous topic :: View next topic »

Author

Message

N521632

Posted: Wed Jun 15, 2005 6:08 am Post subject: TDS Outbound Generation - Require Quotes and Delimiters

Newbie

Joined: 28 Feb 2005
Posts: 2

Our current integration has some very specialized requirements for an outbound document. Each field needs to have double quotes ("FIELD1") and a delimiter ";". (ex. "FIELD1";"FIELD2") Also the record contains 2 or more lines that will be read separately by another program and the delimiter terminating the individual records will be a new line
Example: "HDRVAL1";"HDRVAL2";"HDRVAL3"X'\010'
"LNEVAL1";"LNEVAL2";"LNEVAL3"X'\010'
"LN2VAL1";"LN2VAL2";"LN2VAL3"X'\010'

Has anyone had similar specialized tag and delimiter requirements? We also have to read this format. How can this document be parsed? Is inbound setup (read) different from outbound (write)?

Running WBIMB V5 on Windows and Aix

Regards,
Tom
_________________
Tom White

jefflowrey

Posted: Wed Jun 15, 2005 6:48 am Post subject:

Grand Poobah

Joined: 16 Oct 2002
Posts: 19981

Read and Write are always the same if the same model and physical layer are used.

I would set the tags to " and the delimiters to ";.
_________________
I am *not* the model of the modern major general.

N521632

Posted: Wed Jun 15, 2005 10:59 am Post subject:

Newbie

Joined: 28 Feb 2005
Posts: 2

Setting the tags to " and the delimiters to "; handled the majority of the conditions. The special record terminator and lack of the ';' for the output application is causing the unique parsing requirement. The last data value would not have a "; delimiter, but instead have a "Line Feed character.

EX. "DATAVAL1";"DATAVAL2";"DATAVAL3";"DATAVALLAST"LF (Where LF is the Line Feed Character)

I appreciate the quick response, and thank you for all the information related to this inquiry.

Thanks...
Tom
_________________
Tom White

jefflowrey

Posted: Wed Jun 15, 2005 11:07 am Post subject:

Grand Poobah

Joined: 16 Oct 2002
Posts: 19981

Don't set a delimiter on the last element, set a group delimiter to "<LF>. (<LF> is a TDS mnemonic. Enter it exactly as I typed it.)
_________________
I am *not* the model of the modern major general.

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » TDS Outbound Generation - Require Quotes and Delimiters

Jump to:

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum

Protected by Anti-Spam ACP