Caché MultiValue Query Language (CMQL) Reference
COL.SPACES clause
[Back] [Next]
   
Server:docs2
Instance:LATEST
User:UnknownUser
 
-
Go to:
Search:    

Changes the column display spacing.
Synopsis
COL.SPACES n
Description
The COL.SPACES and COL.SPCS keywords are synonyms.
The COL.SPACES clause enlarges (or shrinks) the spacing between display columns by n spaces. COL.SPACES 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.
COL.SPACES 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.
COL.SPACES uniformly changes the width of all of the display columns. Use FMT to change the width of a single display column.
Examples
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.