sql - DB2 Implied Decimal -

To run LUW, running DB2 8.2 fix-peak 18, I have to convert a DCIML field to IMPLEEDDCIMML for file export.

I can not get anything in the documentation online, please help.

Just multiply the value of the column 10 ^ from the decimal column of the scale and change it to an integer. Therefore, DCIML (12,4) columns: 10 ^ 4 = 10000, and:

For artists (in the form of their call * 10000 bilent)

If the value is 3.1415 The result will be 31415.