Progress/400
Product Guide
Converting from Legacy Unknown Values to SQL NULL Support
Follow these steps to convert your data and definitions from legacy unknown value support to SQL NULL support:
- On your Windows client, dump both your data definitions (.df) and data (.d).
- On the AS/400, run DUPPRODB FRMDB (*EMPTY).
NOTE: This operation creates all data files and fields as SQL NULL enabled.- On your Windows client, reload the data definitions (.df) with the Progress/400 Data Dictionary, accepting the default to allow fields to be null capable.
NOTE: Fields that contain the unknown value are stored as SQL NULL fields in the data files.- On your Windows client, reload the data (.d) once the data definitions are loaded.
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |