The Export to Desktop function allows you to export the contents of a selected FM Base or FM DB2 resource to a CSV or XML file on your desktop.
FM Base Export to Desktop Options
- 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 your 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 you select record sampling, you must specify a non-zero positive integer value 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
- 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 your 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
- Output Location - Location of the output file on your 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 you are using a 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