31-digit decimal support

If you are using QMF Version 3.1 (or later) and are operating in DB2 Version 2.3 (or higher), you have 31-digit decimal support. If you migrate from an earlier version of QMF, or from an earlier database version, you might want to determine which tables are impacted by 31-digit decimal support. The following query retrieves a list of the user tables that might be impacted by the DB2 tables:

SELECT DISTINCT(TBNAME)
   FROM SYSIBM.SYSCOLUMNS
     WHERE COLTYPE IN ('INTEGER', 'SMALLINT', 'FLOAT',
       'DECIMAL', 'DATE', 'TIME', 'TIMESTAMP')
   ORDER BY TBNAME