Specifying the source for the exported data

You can specify the source for the exported data with the ALL, NX, X, or EX parameter to the EXPORT primary command.

When you specify this parameter, FM/Db2 copies all, or selected, rows in the current FM/Db2 editor session to the target data set.

If you omit this parameter, FM/Db2 re-executes the SQL statement that produced the data for the current FM/Db2 editor session. FM/Db2 exports the rows fetched by the SQL statement to the target data set, up to any row limit specified on the export options panel.

You can use the Export Count field on the Export Utility panel to limit the data loaded into the FM/Db2 editor, for large Db2® objects, or arbitrary select statements that generate large result tables. Issuing the EXPORT primary command without the ALL parameter enables all rows for the Db2® object, or result table from the arbitrary select statement, to be written to the export data set.

Related references

• EXPORT primary command
• Export Utility ("From") panel