EXPORT primary command
The EXPORT primary command starts a dialog that allows either the result table currently shown in the FM/Db2 editor session, or rows in the current FM/Db2 editor session, to be exported to a data set.
Syntax
Notes:
- 1 NX, X, EX valid for TABL format only.
- 2 Label range valid for TABL format only.
- NOOPT
- Overrides the current setting for the Show export options option
on the Editor Options (4 of 8) panel. The Export Options panel is
not displayed.
The data format for the export is determined as follows: The current value for the export data format is used, unless a data format parameter is specified in the EXPORT command. In the latter case, the parameter specified in the EXPORT command overrides the current export data format value.
- OPT
- Overrides the current setting for the Show export options option on the Editor Options (4 of 8) panel. The Export Options panel is displayed.
- QUIET
- Overrides the current setting for the Show export options option on the Editor Options (4 of 8) panel. The Export Options panel is not displayed. This option also suppresses the display of the Export "To" panel. The current values specified on the Export "To" panel are used to process the EXPORT command.
- SQLDA
- Data is exported in FM/Db2 internal (SQLDA) format. This is equivalent to specifying 1 for the Data Format option on the Export Options (1 of 3) panel.
- Db2®
- Data is exported in Db2® unload format. This is equivalent to specifying 2 for the Data Format option on the Export Options (1 of 3) panel.
- DSNTIAUL
- Data is exported in same format as that used by the DSNTIAUL sample program. This is equivalent to specifying 3 for the Data Format option on the Export Options (1 of 3) panel.
- USER
- Data is exported in a user-defined data format. This is equivalent to specifying 4 for the Data Format option on the Export Options (1 of 3) panel.
- CSV
- Data is exported in a comma-separated variables (delimited) format. This is equivalent to specifying 5 for the Data Format option on the Export Options (1 of 3) panel.
- ONLINE
- The export is performed on-line.
- BATCH
- Generate a JCL deck to execute the export for the Db2® object or SQL SELECT statement in batch mode. You cannot specify BATCH with any of ALL|NX|X|EX.
- ALL
- Copies all rows in the current FM/Db2 editor session to the target data set.
- NX
- Copies all non-excluded rows in the current FM/Db2 editor session to the target data set.
- X
- Copies all excluded rows in the current FM/Db2 editor session to the target data set.
- EX
- Same as X.
- label1
- Label identifying the start of a range of rows to be processed. The label must start with a period (.) followed by one to four alphabetic characters (no numeric or special characters). Labels starting with the letter “Z” indicate an editor-assigned label.
- label2
- Label identifying the end of a range of rows to be processed. The label must start with a period (.) followed by one to four alphabetic characters (no numeric or special characters). Labels starting with the letter “Z” indicate an editor-assigned label.