Progress/400
Product Guide


Progress Settings File (PROSET)

Progress/400 provides a settings file, called PROSET, that regulates its behavior. This file is located in the Progress library as supplied in the product media. You can change the settings using various OS/400 utilities, including the Data File Utility (DFU).

NOTE: Do not modify any setting that is not documented.

Table 8–4 shows the settings for PROSET and the effects of assigning different values to those settings.

Table 8–4: PROSET Settings
Setting Name
Description
QUEUE-DUPLICATE-SERVER-
MESSAGES
Determines whether the server sends duplicate messages to the client when requested when an error occurs.

Specify YES or Y (the default) to send duplicate messages.

Specify NO or N to not send duplicate messages.

Program/Utility: General
COMMITMENT-CONTROL-SCOPE
When commitment control is started, it is started based on this value.

Specify *ACTGRP to start commitment control for the current activation group only. In most cases, this covers the currently running Progress Server or native clients. Any programs called using either QCMD or EPI usually start their own activation group.

Specify *JOB to start commitment control for the entire job. Any called programs are included in the commitment definition started for the server or the native client. You can regulate the effect of this switch for the client-server environment (PROSERV) and the native environment separately. To do this, enter a record into the PROSET file using each of the two key values.

Program/Utility: PROCLIENT, PROSERV
ALLOW-ZONE-DECIMAL
Determines whether to allow the use of ZONED decimal numbers with decimal digits.

Specify YES or Y to allow the use of ZONED decimal numbers with decimal digits. The actual number of decimal digits is placed into the DDS.

Specify NO or N (the default) to not allow the use of ZONED decimal numbers with decimal digits. ZONED decimal numbers are created with zero (0) decimal digits.

For more information, see the "ALLOW-ZONE-DECIMAL Usage Notes" section.

Program/Utility: CHGPRODCT
MAP-VARIANT-CHARACTERS
Determines whether variant characters (#,@,$) are mapped to underscore (_).

Specify YES or Y (the default) to map variant characters.

Specify NO or N to not map variant characters. However, if a variant character is the first character, map it to “A”.

Program/Utility: CHGPRODCT
ALLOW-SELECT-OMIT-INDEXES
Determines whether to allow Select/Omit Logical files as indexes.

Specify YES or Y (the default) to allow Select/Omit Logical files as indexes.

Specify NO or N to not allow Select/Omit Logical files as indexes.

Program/Utility: CHGPRODCT
USE-CHGPF
Specify whether APYPRODCT will delete and re-create physical files as in prior versions or use the OS/400 CHGPF command.

Specify Yes or Y to use the CHGPF command.

Specify No or N (the default) to use existing methods.

Program/Utility: APYPRODCT
PROCESS-DFT-DDS-KEYWORD
Allows the user to regulate the processing of the DDS keyword DFT. This keyword sets up a DEFAULT value for the field. This DEFAULT value becomes the Progress Initial Value under the following conditions:
- If the field is numeric, the
DFT value is
placed directly into the
Progress initial field.

- If the field is character,
the DFT value is
stripped of quotation
marks and then placed
directly into the Progress
initial field. When
HEX values or *NULL
have been specified
in the DFT keyword, the
Progress initial
value is not loaded.

Specify YES or Y to process the keyword and place it into the Progress initial field.

Specify NO or N (the default) to ignore the DFT DDS keyword.

Program/Utility: CHGPRODCT
EXCLUDE-NULL-KEY-VALUE
Allows you to have more than one record with the UNKNOWN value in the index field when the index is defined as a UNIQUE index. It excludes the UNKNOWN/NULL index value when determining duplicate key values for a UNIQUE index.

Specify YES or Y to add the (*EXCNULL) parameter to the UNIQUE keyword in the DDS of the file on the AS/400. This excludes null values when determining duplicate index values.

Specify NO or N (the default) to include the NULL value in determining duplicate index values.

Program/Utility: APYPRODCT
CHANGE-CHAR-TO-VARLEN
Allows the user to have character fields changed to character variable-length fields during the commit process if the length of a field is greater than the length specified in the VALUE setting of the PROSET setting.

Specify an integer value greater than 0 to enable this change. For example, if you specify ’200’, a character field is changed to a character variable-length field if its length is greater than 200.

Specify 0 to not change character fields to character variable-length fields.

Program/Utility: APYPRODCT
INCLUDE-VIRTUAL-FILES
Determines whether CHGPRODCT processes virtual files.

Specify Y (the default) to process virtual files.

Specify N to not process virtual files.

Program/Utility: CHGPRODCT
INCLUDE-SOURCE-FILES
Determines whether CHGPRODCT processes source files.

Specify Y (the default) to process source files.

Specify N to not process source files.

Program/Utility: CHGPRODCT

NOTE: If variant characters are not mapped, it is possible to create a file or field name that is invalid to Progress/400. For example, the pound sign (#) is a valid character for OS/400 but invalid to Progress/400.

See your Progress/400 Release Notes for additional settings that you can add to your PROSET file.

ALLOW-ZONE-DECIMAL Usage Notes

This section describes how the ALLOW-ZONE-DECIMAL setting in the PROSET file affects files when you use the Progress/400 Data Dictionary to create or modify files.

Setting ALLOW-ZONE-DECIMAL to YES has the following effects:

Setting ALLOW-ZONE-DECIMAL to NO has the following effects:


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