Dump Clause

You can specify a general output format with the Dump clause. The Dump clause specifies that you do not want to print the leading field names.

For example, without the Dump clause you might get:

MQL<30>list format mx* select modified id;
format   mxThumbnail Image 
    modified = 1/28/2006 2:07:16 AM
    id = 0.1.35873.42707
format   mxSmall Image 
    modified = 1/28/2006 2:07:16 AM
    id = 0.1.35873.53610
format   mxLarge Image 
    modified = 1/28/2006 2:07:16 AM
    id = 0.1.35890.47596
format   mxImage 
    modified = 1/28/2006 2:07:16 AM
    id = 0.1.35891.14732

With the Dump clause, the data is easier to parse:

MQL<29>list format mx* select modified id dump;
1/28/2006 2:07:16 AM,0.1.35873.42707
1/28/2006 2:07:16 AM,0.1.35873.53610
1/28/2006 2:07:16 AM,0.1.35890.35949
1/28/2006 2:07:16 AM,0.1.35890.47596
1/28/2006 2:07:16 AM,0.1.35891.14732

You can also specify which character you want to use to separate the fields in the output:

dump [”SEPARATOR_STR”]

SEPARATOR_STR is a character or character string that you want to appear between the field values. It can be a tab, comma, semicolon, carriage return, and so on. If you do not specify a separator string value, the default value of a comma is used. If tabs or carriage returns are used, they must be enclosed in double quotes (“ ”).

When using the Dump clause, all the field values for each object are printed on a single line unless a carriage return is the separator string.