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:
- On new files created with the Progress/400 Data Dictionary, the setting has no effect.
- When you use the Progress/400 Data Dictionary to maintain an existing file that was added with the Progress/400 Data Dictionary and the file contains data, then when the data is copied back into the file and decimals are added, the data is shifted to the left by the number of decimals.
For example, suppose that the Balance field of a record in the customer file in the Progress-supplied PRODEMO sample database contains the value 93545, then you perform maintenance on the file (not necessarily to this field). After performing maintenance, the value in the Balance field is 9354500.
This change happens whenever you perform an action in the Progress/400 Data Dictionary that results in the regeneration of the DDS. This means that if a user adds or deletes a field and does not touch the zoned field, the value in the zoned field still changes.
If you want to set ALLOW-ZONE-DECIMAL to Y but ensure that data values remain correct when you use the Progress/400 Data Dictionary, you must do the following:
- When you either use the Progress/400 Data Dictionary to maintain an existing file that was originally added with CHGPRODCT or perform maintenance using CHGPRODCT, the file maintains the proper decimals and the data values are correct.
Setting ALLOW-ZONE-DECIMAL to NO has the following effects:
- On new files created with the Progress/400 Data Dictionary, the DDS does not have decimals.
- When you use the Progress/400 Data Dictionary to maintain an existing file that was originally added with the Progress/400 Data Dictionary, there are no behavioral changes and the data values remain the same.
- When you use the Progress/400 Data Dictionary to maintain an existing file that was added with CHGPRODCT, the DDS loses the decimals and any data is truncated.
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |