CA DATA-DICT Decimal column Precision value report
Article ID: 126288
Updated On:
Products
Datacom
DATACOM - AD
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 )
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 )
Feedback
Yes
No
Powered by
