Progress
Results User’s Guide
for UNIX


Horizontal Menu Options for the Data Export Module

Define

Defines the files and fields to export.

The Define option in this module works the same way as it does in the Reports module. For example, you select files and fields the same way. Also, the Define option has the same submenu options in both modules, with one exception: the With/Format of Fields option (described in this section). For a complete description of the Define option and its submenu options, see the Define descriptions in "Horizontal Menu Options for the Reports Module" section in this appendix.

When you use the Define option to create a new field (math, date, or string expression, for example), you can redefine the format for the field. (In the Reports module, you can also redefine the label and specify if you want Results to hide its repeating values.)

Width/Format of Fields

Enables you to change the width and format of any field or defined column in the current Data Export Layout window. You can only select this option when the Export Type is set to Fixed-width ASCII (SDF).

The width and field format defines how Results exports the field data. For example, it defines the width of a character field or the number of decimal places in a numeric expression. For information on formats, see "Field Display Formats."

Settings

Determines the export format. When you select this menu entry, you see a scrolling list of the following possible export formats: Progress, Generic ASCII format, ASCII with Field-name header, Fixed-width ASCII (SDF), Comma-separated value (CSV), DIF, SYLK, WordStar, Microsoft Word, Microsoft Word for Windows, WordPerfect, CTOS/BTOS OfisWriter, and User-Sample Export.

NOTE: The User-Sample Export option appears by default when you start Results with a copy of the Progress sports database. When you start with another type of database, you see this option if your database administrator enabled it for you.

When you select any of the options except the ASCII choices, you set the Export Type line in the Export Layout window.

When you select any of the ASCII options, a form pops up for you to fill. The form enables you to define the initialization string at the start of a record, the record termination string, the field delimiter string, and the field separator string for particular export requirements. These values can be entered using several different methods:


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095