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:

  1. On your Windows client, dump both your data definitions (.df) and data (.d).
  2. On the AS/400, run DUPPRODB FRMDB (*EMPTY).
  3. 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.
  4. NOTE: This operation creates all data files and fields as SQL NULL enabled.

  5. On your Windows client, reload the data (.d) once the data definitions are loaded.
  6. NOTE: Fields that contain the unknown value are stored as SQL NULL fields in the data files.


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