Hi all, We have some problems with the decimal function. See the query and query-output below. The query works fine on DB2/6000 for AIX. But for DB2 on OS/390 the decimal results are wrong. When using the float function the results are as espected. On both AIX and OS/390 we use DB2 v7.2 Have you ever had these same problems?
Regards Raoul A. Joemman Martinair Query: ------ SELECT 26.000260 / 286.000000 , DECIMAL (26.000260,17,6) / DECIMAL (286.000000,17,6) , DECIMAL (DECIMAL(26.000260,17,6) / DECIMAL (286.000000,17,6) ,17,6) , FLOAT (26.000260) / FLOAT (286.000000) , DECIMAL ( FLOAT (26.000260) / FLOAT (286.000000) , 17,6) FROM SYSIBM.SYSDUMMY1 ; DB2/6000 AIX output: -------------------- 0.09091000000000000000000 0.09091000000000 0.090910 +9.09100000000000E-002 0.090910 all values are ok! DB2 OS/390 output: ------------------ .0909100 0. .000000 +0.90910000E-01 .090910 is ok is wrong is wrong is ok is ok ***************************************************************** This e-mail and any attachment may contain confidential and privileged material intended for the addressee only. If you are not the addressee, you are notified that no part of the e-mail or any attachment may be disclosed, copied or distributed, and that any other action related to this e-mail or attachment is strictly prohibited, and may be unlawful. If you have received this e-mail by error, please notify the sender immediately by return e-mail, and delete this message. Martinair Holland N.V., its subsidiaries and/or its employees shall not be liable for the incorrect or incomplete transmission of this e-mail or any attachments, nor responsible for any delay in receipt. ***************************************************************** - ::: When replying to the list, please use 'Reply-All' and make sure ::: a copy goes to the list ([EMAIL PROTECTED]). *** To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED] *** For more information, check http://www.db2eug.uni.cc
