DB2 only allows maximum 31 precision for a Decimal( eg. numeric(31,3)) thus when we have something like numeric(38,3) it will fail and liquibase will throw exception. I am wondering if there is a way in liquibase to cap the precision to 31 in its rendering to DB2?
None that I know of. You would need to do something like what Datical does and pre-process the changelog. Datical implements a forecast tool that simulates operations, and also has a rules engine that allows for very detailed checks.
Steve Donie
Principal Software Engineer
Datical, Inc. http://www.datical.com/
