Step 3—Specifying Delimited Format Options
After selecting the Selective Column / Delimited Extract option in the Selective Column / Delimited Prompt pop-up File-AID/RDX displays the following figure where you decide the format of the extract file and which delimited format options to use.
Delimited Format Options screen
COMMAND ===>
Dataset Format ===> 2 (1 = Standard extract file)
(2 = Delimited, not loadable)
Specify Delimited Format Options:
Quotation Marks ===> 2 (1 = Single, 2 = Double)
Column Delimiter ===> ,
Use Quotes on Character Data ===> YES (Yes or No)
Use Quotes on Numeric Data ===> NO (Yes or No)
Extract Column Names ===> YES (Yes or No)
Date Format ===> YYYY-MM-DD (Specify desired mask)
To select Delimited Format for the extract file: | |
|---|---|
In this field… | Do the following: |
Command | Type END |
Dataset Format | Type 2 to select delimited format. |
Quotation Marks | Type 2 to select double quotation marks. |
Column Delimiter | Type , to use the comma as the column delimiter. |
Use Quotes on Character Data | Type YES to use quotes on character data. |
Use Quotes on Numeric Data | Type NO to not use quotes on numeric data. |
Extract Column Names | Type YES to extract column names. |
Date Format | Type MMDDYYYY for the date format. |
Press Enter | File-AID/RDX displays the Object Selection Criteria screen, where you can select which columns to include and apply selection criteria. |
Field Names and Descriptions
The following list describes all of the fields on this pop-up.
FIELD | DESCRIPTION | |
|---|---|---|
Dataset Format | Specify whether the data should be extracted in standard Db2 or delimited file format. You must enter either a 1 or 2, or you receive the error message “Invalid value”. Enter a 1 for standard file format. Enter a 2 for delimited file format. Note: Extracted data in delimited file format cannot be loaded using File-AID/RDX’s Load utility | |
Quotation Marks | Specify which quotation marks, single (’) or double (“) should be used in the delimited file format. Double quotation marks are the initial default. Enter a 1 for single quotation mark. Enter a 2 for double quotation mark. | |
Column Delimiter | Specify which character should be used as the column delimiter. The column delimiter marks the end of the previous and the beginning of the next column. Any displayable character, including blank character, is acceptable. Comma (,) is the initial default. | |
Use Quotes on Character Data | Specify whether character data will be enclosed by quotation marks. When set to YES (initial default), the output looks like “JONES”,”MARY”. Numbers containing special characters, for example date fields, are considered character data. For example, if set to YES the date field could look like this “1995-09-29”. When set to NO output would look like this: JONES,MARY or 1995-09-29. | |
Use Quotes on Numeric Data | Specify whether numeric data will be enclosed by quotation marks. When set to YES, the output looks like “12345”,”6789”. There should not be any decimal points specified for fixed or floating point decimal columns. When set to NO, the output looks like 12345,6789. NO is the initial default. | |
Extract Column Names | Specify whether column names will be included as the first row in the extract file. Column names follow the same format as for Character data. An example is “EMPLOYEE_ID”,”LASTNAME”,”FIRSTNAME” etc. If YES, the extract file includes all selected column names. The initial setting is NO. | |
Date Format | Specify the format to mask date data. Any valid date format is acceptable, for example YYYY/MM/DD, DD.MM.YYYY, or MM/DD/YY. The initial date format is the same as the installation default for date format. | |
Primary Commands
The following list identifies the primary commands that are available from this screen. For details on the command, see File-AID/Related Data XPERT Reference.
COMMAND | DESCRIPTION |
|---|---|
END | Saves your selections and continues to the Object Selection Criteria screen. |
CANCEL | Cancels your selections and returns to the Extract - DB2 Driving Object screen. |