CA DATA-DICT Decimal column Precision value report

Document ID : KB000126288
Last Modified Date : 06/02/2019
Show Technical Document Details
Question:
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?
Environment:
CA Datadictionary
Answer:
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 )