CA DATA-DICT Decimal column Precision value report

book

Article ID: 126288

calendar_today

Updated On:

Products

CA Datacom - DB CA Datacom CA Datacom - AD CA Datacom - Server

Issue/Introduction



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

Resolution

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 )