OnDemand Users Group

Archive => Other => Topic started by: Gobi21 on August 01, 2013, 12:59:06 PM

Title: Decimal Precision issue
Post by: Gobi21 on August 01, 2013, 12:59:06 PM
Hi ,

I am using the commands to create Folder structure in the CMOD.  Below are the commands..

<field name="GIT" description="GIN" fieldType="Decimal" mappingType="Single">
<mapping dbName="GIT" appGroup="TESTF003_1"/>
<fieldInfo group="*PUBLIC" displayOrder="5" queryOrder="5" sortOrder="5" equal="Default" notEqual="Yes" lessThan="Yes" ltOrEqual="Yes" greaterThan="Yes" gtOrEqual="Yes" in="Yes" notIn="Yes" between="Yes" notBetween="Yes" decimalPrecision
="0"/>
</field>


<field name="AMOUNT1" description="AMOUNT" fieldType="Decimal" mappingType="Single">
<mapping dbName="AMOUNT1" appGroup="TESTF003_1"/>
<fieldInfo group="*PUBLIC" displayOrder="7" queryOrder="7" sortOrder="7" equal="Default" notEqual="Yes" lessThan="Yes" ltOrEqual="Yes" greaterThan="Yes" gtOrEqual="Yes" in="Yes" notIn="Yes" between="Yes" notBetween="Yes" decimalPrecision
="6"/>
</field>


Whereever i have the configuration as decimalPrecision= "0", the decimalprecision is updated as "2" instead of "0". The second query updated the decimalprecision as "6" as designed.

It looks very strange for me.

please help me with your insights on this issue.
Title: Re: Decimal Precision issue
Post by: Gobi21 on August 02, 2013, 08:02:15 AM
Hi all,

I got to know it is an known issue in CMOD 8.4.1 version and there is a Fix note available.

http://www-01.ibm.com/support/docview.wss?uid=swg1PM37226


Cheers,
Gobi
Title: Re: Decimal Precision issue
Post by: Ed_Arnold on August 05, 2013, 01:29:41 PM
Are you using decimal to store large integer values?

If so, don't.

Use BIGINT instead.

Ed