ASG
IBM
Zystems
Cressida
Icon
Netflexity
 
  MQSeries.net
Search  Search       Tech Exchange      Education      Certifications      Library      Info Center      SupportPacs      LinkedIn  Search  Search                                                                   FAQ  FAQ   Usergroups  Usergroups
 
Register  ::  Log in Log in to check your private messages
 
RSS Feed - WebSphere MQ Support RSS Feed - Message Broker Support

MQSeries.net Forum Index » Search

 Search found 3 matches
Author Message
  Topic: String to Numeric with Decimal Point
Balraj Muthupandiyan

Replies: 3
Views: 2956
 PostForum: WebSphere Message Broker (ACE) Support   Posted: Wed Mar 09, 2005 7:29 am   Subject: String to Numeric with Decimal Point
Hello Kirani:

If I use the statment CAST(inputdata AS DECIMAL(10,2)) the result is coming out as 5.00 and all the leading zeros are truncated in Version 5. But it works in Version 2.

Is there a ...
  Topic: Version 5 CAST to Decimal truncates Leading zeros
Balraj Muthupandiyan

Replies: 3
Views: 2529
 PostForum: WebSphere Message Broker (ACE) Support   Posted: Wed Mar 09, 2005 7:23 am   Subject: Version 5 CAST to Decimal truncates Leading zeros
Thank you for the reponses.
  Topic: Version 5 CAST to Decimal truncates Leading zeros
Balraj Muthupandiyan

Replies: 3
Views: 2529
 PostForum: WebSphere Message Broker (ACE) Support   Posted: Tue Mar 08, 2005 2:41 pm   Subject: Version 5 CAST to Decimal truncates Leading zeros
Hello:
When I used the following statement in Version 2 the result was 00321.4560, where the value of x=321.456.
CAST(x AS DECIMAL(10,4))

But when I used the same statment in Version 5 the result ...
Page 1 of 1

Jump to:  
Protected by Anti-Spam ACP
  
 


Theme by Dustin Baccetti
Powered by phpBB © 2001, 2002 phpBB Group

Copyright © MQSeries.net. All rights reserved.