Compressing a Character Column containing non-alphabetic characters
Hopefully someone can help me with a problem compressing text values containing non a-z characters, specifically ' and ( .
We have a column containing a number of fixed text entries which we'd like to compress (I'd prefer to convert them into code values but I've been told that's a last resort) and I can't figure out how to code the Compress rule, or if it's even possible.
Normally I'd code something like
TEXT_COL1 CHAR(50) CHARACTER SET LATIN NOT CASESPECIFIC NOT NULL COMPRESS ('Text Value 1', 'Text Value 2')