loadData precision loss on 9,999,999,999,999.99. Truncating pennies

We are using liquibase 2.0.1 and loading in records that have trillion dollar amounts. Liquibase is truncating the penny amounts for 9,999,999,999,999.99.


Load data looks like this.


<changeSet id=“1” author=“load” >

<loadData tableName=“acct” file=“resources/accts.csv”>

<column name=“ID” type=“NUMERIC”/>

<column name=“amount” type=“NUMERIC”/>

We are on DB2 Z/OS which bombs if you don’t explicitly declare a numeric type as NUMERIC. When liquibase tries to do the insert, it wraps single quotes around the amount and bombs b/c the column is of DECIMAL type. However, NUMERIC has precision loss after it is a single digit trillion amount. Any ideas on a work around or a way to get it to stop truncating the penny amounts.