The Export to Desktop function allows the contents of a selected FM Base or FM DB2 resource to a exported to a CSV or XML file on the desktop.
FM Base Export to Desktop Options

Parameter mappings:
- Resource: A unique identifier for a FM Base resource which includes data sets, USS files, CICS files/TD queues/TS queues, and WebSphere MQ queue.
- Volume serial: Serial number of the volume which contains the data set. Required for data sets which are not cataloged.
- Copybook or Template: Fully qualified data set member name where a copybook or FM template is stored to format the data.
- Start position type: One of NONE, KEY (valid for VSAM KSDS, VSAM AIX, or VSAM PATH), RBA (valid for VSAM KSDS, VSAM AIX, or VSAM ESDS), or RECORD_NUMBER. Based on the selection, Start position value is interpreted accordingly.
- Start position: Value to use for the starting position.
- Record sampling: If selected, a non-zero positive integer value must be specified for Include physical records and Skip physical records. Include physical records represents the number of physical records to be included in a repeating sample from the data set. Skip physical records represents the number of physical records to be skipped.
- Record limit: Total number of physical records to be read from the source.
- Include only selected records: When this option is selected, only the records selected by template processing will be included in the editor session.
- Binary record length: If this option is selected, the data is assumed Binary and processed without record delimiters.
- Encoding: The default encoding to use when converting the value stored in a text field.
- I/O exit name: Name of the user I/O exit routine. I/O exit usage must be enabled in the options module.
Back to top
FM DB2 Export to Desktop Options

Parameter mappings:
- DB2 Subsystem: A DB2 sub-system/group identifier.
- Owner: Name of the owner of the DB2 object to export from.
- Name: Name of the DB2 object to export from.
- Template Data Set Name: Optional fully qualified data set member name where the FM DB2 template is stored.
- Start position: A number used to indicate where FM DB2 should begin loading rows from.
- Row count: A row count limit. Limits the number of rows to be processed.
- Encoding: Encoding value to use when converting the value of a text column.
- GRAPHIC Encoding: Encoding value to use when converting the value of a GRAPHIC column.
Back to top
Common Export to Desktop Options

Parameter mappings:
- Output Location: Location of the output file on the user's desktop computer
- Output format: Select either CSV or XML output format
- CSV: Values are exported in CSV format. Embedded quotes, blanks and delimiters will be escaped.
- XML: Values are exported in XML format.
- Include column names: Exports column names when exporting in the CSV format. If using an FM Base template with multiple layouts, column headers are printed each time the current layout changes while processing records.
- CSV Options
- Separator character: Use this field to specify an alternate delimiter value to ','.
- Include fillers: Select this option to include filler fields in the CSV output.
- Include redefines: Select this option to include redefines fields in the CSV output.
- Include leading blanks: Select this option to preserve the leading blanks for field values.
- Include trailing blanks: Select this option to preserve the trailing blanks for field values.
- Quoted values: Select this option to wrap the output field values in quotes (default double quotes).
- Single quotes fillers: Select this option to use single quotes when encapsulating values rather than the default double quote.
- As is encapsulation: Select this option to disable encapsulation of values that are already encapsulated.
Back to top
Common Result Dialog

- Message: Informs the user of how many records were exported to the file or an error if a problem occurred
- Show File button: Display the exported file in a text editor and close the dialog
- OK button: Closes the dialog
Back to top