MQSeries.net :: View topic - Convert CHAR to INT

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 » Convert CHAR to INT

Convert CHAR to INT

« View previous topic :: View next topic »

Author

Message

Segs

Posted: Wed Jan 02, 2002 2:14 pm Post subject:

Voyager

Joined: 04 Oct 2001
Posts: 78
Location: Zurich Financial Services

I'm trying to convert a char field defined as a CHAR(4) in the MRM to an integer. The esql I'm using is as follows:

DECLARE X AS Integer;

Set X = CAST(InputRoot.MRM.LINE_COUNT As INTEGER);

but whenever I run the the flow I get a message saying that it received a CHAR when it expected an INTEGER.

Any ideas, do I need to use the EVAL function for the CAST?

Thanks

Segs...

mpuetz

Posted: Mon Jan 07, 2002 9:09 am Post subject:

Centurion

Joined: 05 Jul 2001
Posts: 149
Location: IBM/Central WebSphere Services

Hi,

just an idea: maybe it helps to
get rid of extra whitepspace by using TRIM

set X = CAST(TRIM(InputBody.field) AS INTEGER);

_________________
Mathias Puetz

IBM/Central WebSphere Services
WebSphere Business Integration Specialist

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Convert CHAR to INT

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