MQSeries.net :: View topic

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 » RE: Cast

RE: Cast

« View previous topic :: View next topic »

Author

Message

arun4ruu

Posted: Tue Jun 26, 2012 6:56 am Post subject: RE: Cast

Newbie

Joined: 13 Jan 2012
Posts: 8

How to cast 9619 to 96.19 in ESQL..

Really Appreciate Your Help

mqjeff

Posted: Tue Jun 26, 2012 7:00 am Post subject:

Grand Master

Joined: 25 Jun 2008
Posts: 17447

Substring?

CAST?

Call external procedure?

Make sure the message definition is properly configured?

kash3338

Posted: Tue Jun 26, 2012 9:08 am Post subject: Re: RE: Cast

Shaman

Joined: 08 Feb 2009
Posts: 709
Location: Chennai, India

arun4ruu wrote:

How to cast 9619 to 96.19 in ESQL..

Really Appreciate Your Help

You can never cast 9619 to 96.19. If you want to convert 9619 to 96.19 using esql, divide 9619 by 100 (9619/100).

arun4ruu

Posted: Tue Jun 26, 2012 11:48 am Post subject:

Newbie

Joined: 13 Jan 2012
Posts: 8

Thank You All.

I coded and I got it.

DECLARE VAL DECIMAL 9619;
DECLARE VALU DECIMAL;
SET VALU = CAST((VAL / 100) AS DECIMAL(16,2));

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » RE: Cast

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