| Author |
Message
|
| mahesh2069 |
 Posted: Tue Oct 08, 2013 5:24 am Post subject: How to convert string type to long type in esql |
 |
|
Centurion
Joined: 26 Jun 2013
Posts: 103
|
Hi All,
I want to convert xml to mrm type , Here one element I need to convert String type to long type, So I need to cast it , But in esql I have not find long data type in ESQL, So I will convert String to integer , I think that long element accept integer type , But ESQL Throws Exception like "Message Definition Mismatch "
_________________
Thanks & Regards
Mahesh Mediboyina
WMB Developer |
|
| Back to top |
|
 |
| mqjeff |
| Posted: Tue Oct 08, 2013 5:29 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
You don't have an XML type.
You don't have an MRM type.
You have a field in the logical message tree in the input root.
You have a field in the logical message tree in the output root.
You also have not given a full and proper error message, nor shown your CAST statement.
So no further troubleshooting assistance can be given, other than "yes, you need to troubleshoot".
Best of luck! |
|
| Back to top |
|
|
| mahesh2069 |
| Posted: Tue Oct 08, 2013 5:37 am Post subject: |
|
|
Centurion
Joined: 26 Jun 2013
Posts: 103
|
In output mrm type I taken one element type as xsd:long,
For that I need to assign Long type of data to that element , Here I got character type of data to that element , So I need to type cast it to long .
In ESQL there is no long type data type. So Here I rise an Exception like data Mismatch .
In ESQL how to convert character type to Long type ?
_________________
Thanks & Regards
Mahesh Mediboyina
WMB Developer |
|
| Back to top |
|
|
| mahesh2069 |
| Posted: Tue Oct 08, 2013 5:38 am Post subject: |
|
|
Centurion
Joined: 26 Jun 2013
Posts: 103
|
Here XML ,and MRM are the Parsers ,and I need to take those message types.
_________________
Thanks & Regards
Mahesh Mediboyina
WMB Developer |
|
| Back to top |
|
|
| mqjeff |
| Posted: Tue Oct 08, 2013 5:39 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
| mahesh2069 wrote: |
In output mrm type I taken one element type as xsd:long,
For that I need to assign Long type of data to that element , Here I got character type of data to that element , So I need to type cast it to long .
In ESQL there is no long type data type. So Here I rise an Exception like data Mismatch .
In ESQL how to convert character type to Long type ? |
Maybe you should ask a WMB developer.
There is no LONG type in ESQL, as you have found out. In fact, there is no String type either.
You are working with the logical message tree, not XML data, not MRM data.
If you don't know that, you are not a WMB developer. |
|
| Back to top |
|
|
| mahesh2069 |
| Posted: Tue Oct 08, 2013 5:57 am Post subject: |
|
|
Centurion
Joined: 26 Jun 2013
Posts: 103
|
Hello ,
I know there is no long data type in esql, I instead of character In flow I said string , I think you know Java , In that stream of character are called as String.
I faced problems convert character type data to long type in Message Type . But in ESQL no long type is there , But in my Message Type Contain Long type, So I need to submit long type of Data.
how it possible in ESQL ?
_________________
Thanks & Regards
Mahesh Mediboyina
WMB Developer |
|
| Back to top |
|
|
| lancelotlinc |
| Posted: Tue Oct 08, 2013 6:11 am Post subject: |
|
|
Jedi Knight
Joined: 22 Mar 2010
Posts: 4941
Location: Bloomington, IL USA
|
| mahesh2069 wrote: |
Hello ,
I know there is no long data type in esql, I instead of character In flow I said string , I think you know Java , In that stream of character are called as String.
I faced problems convert character type data to long type in Message Type . But in ESQL no long type is there , But in my Message Type Contain Long type, So I need to submit long type of Data.
how it possible in ESQL ? |
Mahesh,
What mqjeff is pointing out is you are not understanding some basic product concepts.
The single structure in WMB that developers interrogate and modify is called the Logical Message Tree (LMT).
The WMB product contains parsers/serializers. One is called MRM which stands for Message Repository Manager. Another is called XMLNSC which is XML Namespace-aware Compact.
When a message arrives at a WMB input node, its parser gets called to convert the BLOB into an LMT structure. A WMB developer can use Compute nodes to modify this tree. When the LMT hits an Output node, it's serializer gets called.
Knowing this, think about FLOAT, INTEGER types within the ESQL langauge.
If you cannot grasp these principles, perhaps software development is not your forte' and you consider an other vocation like system administration.
HTH
Lance
_________________
http://leanpub.com/IIB_Tips_and_Tricks
Save $20: Coupon Code: MQSERIES_READER |
|
| Back to top |
|
|
| Vitor |
| Posted: Tue Oct 08, 2013 6:15 am Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| mahesh2069 wrote: |
| I faced problems convert character type data to long type in Message Type |
Which you still haven't given details of except in the vaugest terms.
As my most worthy associate points out, you're not dealing with anything in the message type. You're dealing with a logical tree of data.
| mahesh2069 wrote: |
| But in ESQL no long type is there , But in my Message Type Contain Long type, So I need to submit long type of Data. |
Gosh, maybe IBM forgot about xsd:long when they designed ESQL. 
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| dogorsy |
| Posted: Tue Oct 08, 2013 6:43 am Post subject: |
|
|
Knight
Joined: 13 Mar 2013
Posts: 553
Location: Home Office
|
| mqjeff wrote: |
If you don't know that, you are not a WMB developer. |
I have questioned that before... |
|
| Back to top |
|
|
| kimbert |
| Posted: Tue Oct 08, 2013 6:45 am Post subject: |
|
|
Jedi Council
Joined: 29 Jul 2003
Posts: 5542
Location: Southampton
|
| Quote: |
| One is called MRM which stands for Message Repository Manager |
You're about 8 years behind the curve on that. 'MRM' doesn't officially stand for anything any more. It is just a name for a WMB domain.
_________________
Before you criticize someone, walk a mile in their shoes. That way you're a mile away, and you have their shoes too. |
|
| Back to top |
|
|
| Simbu |
| Posted: Wed Oct 09, 2013 3:47 am Post subject: |
|
|
Master
Joined: 17 Jun 2011
Posts: 289
Location: Tamil Nadu, India
|
|
| Back to top |
|
|
|
|
