Step 2—Selecting Selective Column / Delimited Option
When File-AID/RDX determines that you have chosen a single table extract, it displays the following Selective Column / Delimited Prompt to enable Selective Column extract and output of the extract file as delimited.
Selective Column / Delimited Prompt
Select the Selective Column / Delimited Option for the extract: | |
|---|---|
In this field… | Do the following: |
Command | Leave set to G to submit the extract job as soon as you complete the extract request. |
Selective Column / Delimited Extract | Type Y to select the Selective Column / Delimited Option. |
Press Enter | File-AID/RDX displays the Delimited Format Options Screen, where you decide the format of the extract file and which delimited format options to use. |
Field Names and Descriptions
The following list describes all of the fields on this pop-up.
FIELD | DESCRIPTION | |
|---|---|---|
Selective Column / Delimited Extract | Enter Y to enable Selective Column extract and/or output of the extract file as delimited. Selective Column Extract Selective Column Extract allows you to specify the columns of an Object you want to extract. You can indicate the order of the columns and in addition, you can indicate the order that you would like to see the rows extracted. Selection criteria can also be entered for each column. A standard extract data set is created which can be used to load data. Delimited Extract Delimited Extract creates an extract data set which may be loadable into other RDBMS or spreadsheets that accept delimited file format. Selective Columns are allowed with the Delimited format. A Delimited Extract file is not loadable in File-AID/RDX. Enter N to continue with a standard extract without Selective Column or Delimited Extract options. | |