From past versions I have some DECIMAL columns in DATA-DICT with incorrect Precision values.
How can I list those columns that I need to correct in DATA-DICT?
Run following query to find back the problem columns:
SELECT DISTINCT(A.SQLNAME) , A.AGR_SQLNAME , A.ENTITY_NAME , A.CLASS , A.SIGN , A.LENGTH , A.DECIMALS , A.PRECISION FROM SYSADM.FIELD A
WHERE A.STATUS = 'P' AND A.ENTITY_TYPE = 'FLD' AND A.TYPE = 'D'
AND A.ENABLE = 'Y' AND A.PRECISION ¬= ((A.LENGTH * 2 ) - 1 )