simply put I am trying to get rid of all of these DECFLOAT types in my database as a lot of reporting tools (such as Tableau) don't want to work with them. I am new to DB2 and have found a lot of literature online to go from any data type -> DECFLOAT, but nothing substantial about going from DECFLOAT -> INT.
Is this even possible? Any recommendations?
Casting DECFLOAT to integer is supported according to Table 2. Supported casts between built-in data types and in fact you can achieve conversion to any of these: SMALLINT, INTEGER, BIGINT, DECIMAL, DECFLOAT, REAL, DOUBLE, CHAR, VARCHAR (depending on the data, e.g. there are limits to how large a smallint can be).
But why would you alter the table columns to integer? Why not DECIMAL instead? Or, don't alter your tables to suit BI products, instead use views that cast to decimal. You could also control rounding through views.
Whilst today's BI tools may have issues with this data type, that data type is based on standard EEE754r and in future versions of BI tools it may be less of a problem. Perhaps read DECFLOAT: The data type of the future before altering any tables.