| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| tds forcing delimiters |
« View previous topic :: View next topic » |
| Author |
Message
|
| hornbeam123 |
 Posted: Mon Apr 26, 2004 10:46 am Post subject: tds forcing delimiters |
 |
|
Centurion
Joined: 01 Nov 2003
Posts: 101
|
I have created a csv message using mqsi 2.1 using tds. One problem is commas being dropped when the last non-null value was several fields in, e.g. say the csv stream is f1,f2,f3,f4,f5 but only fields f2 and f3 are populated then I get ,data2,data3
and not ,data2,data3,,, which the receiving application is expecting. I could define a filler type field at the end and set as space or something. Is there a property in tds I have missed? |
|
| Back to top |
|
 |
| Missam |
| Posted: Mon Apr 26, 2004 11:30 am Post subject: |
|
|
Chevalier
Joined: 16 Oct 2003
Posts: 424
|
No you didn't missed any thing.This was an Issue In MRM(TDS).
you can do one thing.HardCode delimiter for the last Field.
By the way what level of CSD's are you using. |
|
| Back to top |
|
|
| kimbert |
| Posted: Wed Apr 28, 2004 2:09 am Post subject: |
|
|
Jedi Council
Joined: 29 Jul 2003
Posts: 5542
Location: Southampton
|
| This is fixed in v5.0 CSD2, so you would need to upgrade to get the proper solution. |
|
| Back to top |
|
|
| hornbeam123 |
| Posted: Thu Apr 29, 2004 11:03 am Post subject: tds forcing delimiters |
|
|
Centurion
Joined: 01 Nov 2003
Posts: 101
|
Thanks for your help.
In the end I set GROUP TERMINATOR to my delimiter character "," on the TDS tab for MessageSet and all the trailing commas were output. including the last 'null' field. Btw I am on csd5.
Flow is now ready for user testing.
One problem never solved was having a main message that was always output and an additional chunk that was only output under certain input criteria. Introducing the group terminator meant that commas were output for these fields even when they were not reqd so for now we have popluated one of the secondary fields with a dummy end value. From reading other threads on this forum Isuspect this sub-message can be handled by MRM. Any quick pointers would be appreciated may help for next time. |
|
| Back to top |
|
|
|
|
|
| |
|
Page 1 of 1 |
|
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
|
|
|
|
