Progress/400
Product Guide
Progress Unknown Value Support
Progress/400 uses SQL NULL support to provide the Progress unknown value. The DB2/400 field must allow nulls to support this feature.
When you create a field using the Progress/400 Data Dictionary, you can select Null Capable, which allows the field to have no initial value. If you assign a question mark (?) in the Initial Value field of the field Property sheet, no initial value is assigned. If you want to assign a value to a NULL capable field, use the ASSIGN or UPDATE statements and enter data.
Follow these steps to select the NULL Capable option for a field:
- Choose the Field mode button in the Progress/400 Data Dictionary main window.
- Choose Modify Schema.
- Select the table that will contain the new field from the Tables list.
- Choose the Create Field button. The following dialog box appears:
![]()
You can select the Mandatory or the Null Capable option setting. Table 2–4 displays possible settings for these two values. This table also describes which assignments are allowed based on these option settings.
- Enter a question mark (?) in the Initial Value field.
- Activate the Null Capable option.
NOTE: If you currently have data files that do not support SQL NULLs and have the legacy unknown value, see "Legacy Support and the Progress Unknown Value."
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |