Kbase P18969: Missing DB2/400 default value definitions causing default value not properly set inserting records
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
15/10/2008 |
|
Status: Verified
FACT(s) (Environment):
Progress/400 DataServer
Progress 9.1C
SYMPTOM(s):
When inserting records into the same DB2/400 database from an OS/400 native utility such as the Data File Utility (DFU), the default values are not properly set.
Migrated database from Progress to DB2/400 by loading data definitions (.df file) into the DB2/400 database via Data Administration.
Default values are correctly defined in the converted DB2/400 database when looking at its definitions in the PROGRESS/400 Data Dictionary Tool.
Default values are correctly assigned to database fields when inserting records into the DB2/400 database from Progress 4GL.
Default values are not actually defined in the Data Description Specification (DDS) file.
CAUSE:
BUILD-DDS-DFT-KEYWORD had a value of N when the DB2/400 database definitions were loaded in the AS/400 box.
FIX:
Set the BUILD-DDS-DFT-KEYWORD property to Y in the PROSET file using an OS/400 utility such as the Data File Utility (DFU). PROSET is a settings file provided by Progress/400 to regulate DataServer behavior. This file is located in the Progress library supplied in the product media.