| Author |
Message
|
| burman.abhishek |
 Posted: Thu Jan 18, 2007 1:20 am Post subject: Converting delimited String data into message set |
 |
|
Apprentice
Joined: 23 Aug 2006
Posts: 37
|
I am having string in the format
e.g. "abc^def^ghij^...."
which is caret delimited stored in database table's column.
I will query the table and get the string data from one column.
Now, after querying the data I want to map this data into TDS message set.
One way of doing is i will convert the whole string into BLOB and then pass this BLOB to parse clause.One problem in this is Converting String TO BLOb is still complex.
Anybody has any idea,pls respond.
_________________
With warm Regards,
Burman |
|
| Back to top |
|
 |
| pathipati |
| Posted: Thu Jan 18, 2007 5:28 am Post subject: |
|
|
Master
Joined: 03 Mar 2006
Posts: 296
|
Why do you want to convert it in to BLOB?
You can do the parsing without converting in to BLOB.. |
|
| Back to top |
|
|
| burman.abhishek |
| Posted: Thu Jan 18, 2007 10:42 pm Post subject: |
|
|
Apprentice
Joined: 23 Aug 2006
Posts: 37
|
I don't want to convert it into BLOB.I wanted to know how to parse string(caret delimited) which is coming from database into message set.
_________________
With warm Regards,
Burman |
|
| Back to top |
|
|
| elvis_gn |
| Posted: Fri Jan 19, 2007 12:19 am Post subject: |
|
|
Padawan
Joined: 08 Oct 2004
Posts: 1905
Location: Dubai
|
Hi burman.abhishek,
You don't need to parse it to BLOB.
You could get the data in a java compute node and use the parse against a message set (but validation won't work, atleast it didnt when I tried a few months back, maybe the fixpacks fixed that)....don't think parse against message set is possible within esql.
Else you can have some logic of fetching that data and parsing it using a RCD...
Regards. |
|
| Back to top |
|
|
| broker_new |
| Posted: Fri Mar 23, 2007 3:06 pm Post subject: |
|
|
Yatiri
Joined: 30 Nov 2006
Posts: 614
Location: Washington DC
|
The best option is convert into a blob message and using the
parse the message into a TDS message set using the Create parse command
_________________
IBM ->Let's build a smarter planet |
|
| Back to top |
|
|
|
|
