Copying data from a File Manager/Db2 editor session, or from an SQL statement

Use the EXPORT primary command to write data from the current FM/Db2 editor session to an external file. Alternatively, you can re-execute the SQL statement that generated the data for the current FM/Db2 editor session and write rows for this select statement to an external file. For the second option, you can generate a JCL deck to perform the export operation using batch processing.

Data can be exported in the same data formats as for the Export utility (3.7).

During the export process, the Export Utility panel is optionally displayed. You enter the data format for the exported data on this panel.

The Export "To" panel is also optionally displayed. The Export "To" panel enables you to:
  • Specify the name of the data set that will contain the exported data.
  • Specify the name of a data set that contains a template or copybook, that describes the exported data.
  • Specify a processing option for the template data set.
  • Specify a disposition option for the export data set.
  • View and possibly change the export options.
  • Use the template editor to display and possibly change the mapping between the source and data to be exported.

Related references