In DB2 zOS V10 - I have a column defined as CHAR 14 not nullable when trying to count the characters
in the column CHARACTER_LENGTH(PROCD_DIAG_CD_VAL,OCTETS)
the result set is always 14 even if the column has the value of 'ABCDEF'
Is there a way to accurately get the number of characters of this column?
SELECT PROCD_MSTR_KEY AS
PROCD_DIAG_CD_VAL AS "CODE" ,
CHARACTER_LENGTH(PROCD_DIAG_CD_VAL) AS "LENGTH"
Derez D. Lusk
BlueCross BlueShield of Il/TX/OK/NM/MT
Chicago, Illinois 60601