Progress
Results Administration
and Development Guide
Standard Export Formats
The
results.l
file contains several lines that define the standard export formats available for use in the export view of a query. Each line that defines an export format has the following syntax.
The integer argument is a unique integer value that identifies the export format definition. The integers used to identify export formats must be sequential. The code parameter followed by a value defines the export format. All codes specified for an export format must be enclosed within a single set of double quotes and must be separated using a vertical line ( | ). Table C–2 provides information about the different definitional codes for an export format.
Table C–2: Definitional Codes for Export Formats Code Description 1= Specifies an integer representing the ASCII value of a character to start each line of the export. If you want to specify more than one character, specify a comma-separated list of integers. There is no default character for this setting. 2= Specifies an integer representing the ASCII value of a character to end each line of the export. If you want to specify more than one character, specify a comma-separated list of integers. There is no default character for this setting. 3= Specifies an integer representing the ASCII value of a character to delimit each field of the export. If you want to specify more than one character, specify a comma-separated list of integers. There is no default character for this setting. 4= Specifies an integer representing the ASCII value of a character to separate each field in a line of the export. If you want to specify more than one character, specify a comma-separated list of integers. There is no default character for this setting. b= Specifies the base date for a DIF export. The default value is the unknown value (?). If you do not specify a base date, then all dates are exported as character values. d= Specifies the data types to delimit as fields using the characters specified with the “3=” code. Data type specifications are represented as integer values.
1 CHARACTER
2 DATE
3 LOGICAL
4 INTEGER
5 DECIMAL
6 RAW
7 RECID
Do not separate data type integers with commas or spaces. For example, d=123 specifies the CHARACTER, DATE, and LOGICAL data types. The default value is an asterisk (*), representing all data types. f= Specifies “y” for a fixed width export. The default value is “n” for a variable-width export. h= Specifies “y” to include field headers in the export. The default value is “n.” i= Specifies “y” if the export program (p=) requires a prepass to count records. The default value is “n.” l= Specifies a label for the export format. This label represents the format in Results. p= Specifies the name of the Progress procedure that generates the export. Results currently supports the following export procedures:e-pro
Progress export proceduree-ascii
ASCII export proceduree-dif
DIF export proceduree-sylk
SYLK export procedureTheu-export.p
procedure is a sample export procedure. See "Programming Results," for more information about this procedure. t= Specifies a name for the export format. Results uses this name to manage the format, so the name must be unique.
The following excerpt from the
result.l
file shows some export format definitions:
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |