Caché MultiValue Query Language (CMQL) Reference
Changes the column display spacing.
clause enlarges (or shrinks) the spacing between display columns by n
adjusts the width of all display columns equally. The n
argument can be a positive or negative integer.
The default column widths are specified in the dictionary file listing FORMAT column, as displayed, for example, using LIST DICT VOC
only affects column spacing in horizontal orientation. It has no effect on data displayed in vertical orientation. Vertical orientation can either be caused by specifying too many items for horizontal display, or by specifying the VERT keyword. When displaying multiple items, you can use COL.SPACES
to shift display orientation from vertical to horizontal (negative n
) or horizontal to vertical (positive n
Note that decreasing the spacing between columns may result in displayed data appearing truncated if the column width is narrower than the number of characters in the data.
uniformly changes the width of all of the display columns. Use FMT
to change the width of a single display column.
The following example increases the spacing between display columns by 5 spaces:
LIST VOC F1 F2 F3 COL.SPACES 5
The following example decreases the spacing between display columns by 2 spaces:
LIST VOC F1 F2 F3 F4 F5 COL.SPACES -2
In this example, this is enough to shift display orientation from vertical to horizontal.