Decimal Precision issue

[Gobi21]

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.

[Gobi21]

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

[Ed_Arnold]

Are you using decimal to store large integer values?

If so, don't.

Use BIGINT instead.

Ed