C-ISAM: COMPRESS with two-parts index

Hi! I'm a new user of Informix C-ISAM, and I have some beginner's questions. Please forgive me if they've been often asked here: I carefully Read The Fantastic Manual (RTFM), but I still ask... My first question concerns compressing techniques for two-parts indexes. I have an index composed of a string 'name' (type:CHARTYPE, length:32) and a long integer 'id' (type:LONGTYPE, length:LONGSIZE). There may be several identical 'name's, but the combination of 'name' and 'id' ensures unicity, thus I can (and I do) use flag ISNODUPS. My key is: struct keydesc the_key = { ISNODUPS + LCOMPRESS + TCOMPRESS, 2, { { 32, 32, CHARTYPE }, { 64, LONGSIZE, LONGTYPE } } }; The question is whether the flag TCOMPRESS can be of some use. If I didn't have the 'id', the answer would be clearly YES, because the names are usually less than 32 bytes long. But if compressing technique is applied after concatenating both indexes, then it would be impossible to have a series of blanks at the end of the key... Could someone help me ? -- \\\\\\\\ //// (o o) (o o) +----------oOO--(_)--OOo--------------------oOO--(_)--OOo----------+ | mailto:O.Miakinen@frcl.bull.fr Phone: 33 (1) 30 80 70 42 | | http://www-ism.bull.com/ism Fax: 33 (1) 30 80 79 18 | +-------------(_)-(_)--------------------------(_)-(_)-------------+