Tweet
In DDS, I have the following definitions in a data dictionary: A CSTCDE 6A COLHDG('Constant Code') A ACCTYP R REFFLD(CSTCDE) A COLHDG('Accessory Type') A ACCCAT R REFFLD(CSTCDE) A COLHDG('Accessory Category') Where CSTCDE is a custom data type and is defined only to be referenced by other more meaningful definitions. How can this be defined in SQL? Create Distinct Type CSTCDE As Char(6) With Comparisons then what?