Specify Parameters for the Extract Process

Description

A description indicates the type of information in the Extract Request or provides other useful information. Developing a convention for descriptions can help you categorize Extract Requests.

For this scenario, type a description.

Server Name

Directing resource-intensive processing to a server potentially minimizes network traffic and maximizes efficiency. Server Name indicates the server or workstation used to run the Extract Process. If the Optim™ Server option is not installed (as for this scenario), you must use your local workstation to process the Extract Request. If the Server option is installed, you can select a server on which to process the Extract Request.

Extract File

The Extract File contains a copy of the specified source data. When specifying an Extract File, you can include one or more Optim macros to dynamically create a unique file name. When you run the Extract Process, Move resolves any macros and generates the file name.

Move adds the default .xf extension for Extract Files. If you do not include a path with the file name, the default Data Directory specified in Personal Options is used.

For this scenario, use a macro with the file name and type “scenario<$SEQ>”. The sequence number is increased by a single digit each time Move generates a file name that contains the macro.

Access Definition Options

Access Definition Options let you specify the type of Access Definition used in the Extract Request. An Access Definition describes the set of data to be extracted, governing the overall Extract Process. You can create a Local Access Definition, which is exclusive to the current Extract Request, or you can specify the name of a new or existing Access Definition, which can be used with other process requests.

For this scenario, select Local.

Items to Extract

You can choose to extract Data rows only, Object definitions only, or Both. The Extract Process always extracts column and table definitions, which can be used to create the destination tables, if necessary. You can also choose to extract other object definitions, including primary keys, relationships, and indexes.

If you choose to extract additional object definitions, you can select the objects in the Objects tab. By default, all objects are selected on the Objects tab.

For this scenario, select Both.

Row Limit

A row limit is the maximum number of rows to extract. For example, if you expect to extract fewer than 10 million rows, you can use a row limit to cause the Extract Process to fail if the number of extracted rows exceeds 10 million. A row limit can be any value between 1 and the maximum limit specified in Product Options.

For this scenario, do not specify a row limit.

Run Convert After Extract

Move can automatically perform the Convert Process on the Extract File after the Extract Process. The Convert Process can transform or mask data in the Extract File.

When you select this check box, the Convert tab in the Extract Request Editor is enabled. Use the Convert tab to specify whether to use a named or local Convert Request.

For this scenario, do not select the convert option.

Compress Extract File

If you select this check box, Move automatically compresses the Extract File created by the Extract Process.

For this scenario, select the Compress Extract File check box.

Generate Statistical Report

You can select this check box to include statistical information in the Extract Process Report.

For this scenario, do not select the statistical report option.

Process File Attachments

You can use this check box to extract file attachments specified in the Access Definition.

For this scenario, leave this check box selected, which is the default.