Input Values

Field Description
OUT

Required for CSV Data Server requests.

Specify CSV (comma-separated values format) or XML output.

The default is XML.

DELIM

Sets the field delimiter to a specified character. If a comma is defined as the delimiter character, the text and date fields are enclosed with quotation marks.

The default is , (comma).

OTMMAX

The maximum number of one-to-many related records to return. The default is 25.

There is no absolute maximum set; however queries with a very large OTMMAX value may result in errors.

This parameter requires the OTMDELIM parameter.

OTMDELIM

Required with the OTMMAX parameter.

Sets the one-to-many field delimiter to a specified character. If this value is not specified, only the first one-to-many value found is returned.

NOHEADER

Disables column headers.

NOHEADER does not take a value; its inclusion in the query string is sufficient to disable column headers. Its default value is TRUE; you must specify NOHEADER=, not NOHEADER, where NOHEADER=TRUE.

NEXT

Enables the next and previous strings in the output.

NEXT does not take a value; its inclusion in the query string is sufficient and its default value is TRUE. You must specify NEXT=, not NEXT, where NEXT=TRUE.

CVSKEYS

A TRUE/FALSE flag to indicate that the record keys should be returned with a CSV call.

Note: In CGI DME, this was done when the output type of CSV2 was used with the SORTRECKEYS parameter.

The default is FALSE.

METADATA

Enables display of field metadata:

  • ONLY specifies that no data records are returned, just the metadata.

  • COMB specifies a combination of data records and metadata are returned.