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 (escape values) - Values are escaped with double-quotes. If a column value contains a
double-quote, it is prefixed with an additional double-quote to escape.
- CSV (no escape values) - Values are exported in the original 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.
Back to top