In order to bring you the best possible user experience, this site uses Javascript. If you are seeing this message, it is likely that the Javascript option in your browser is disabled. For optimal viewing of this site, please ensure that Javascript is enabled for your browser.
Login  |   Cloud ERP  |   Home  |   qad.com



  •     QAD Glossary

  • Dumping and Loading Data
    Dump/load programs move the contents of database tables into or out of ASCII files. The dump procedure reads a database table, puts quotation marks around the data value of each field, and places those values in an ASCII file.
    Example: A record in the user master table (usr_mstr) consists of the following entries:
     
    usr_lang
    FR
    usr_site
    1000
    usr_user1
     
    usr_user2
     
    usr_user ID
    pxr
    One line in the dump file would read:
    “FR” “1000” “”“”“pxr”
    You can use dump files as input to other programs after converting the files to CIM input-file format. You can also take output from other programs, convert it to CIM input-file format, and load it into the database. This assumes the data has the correct form, based on the screen flow and format the CIM input is duplicating. The Database Definitions book contains details on specific table formats.
    See Using the CIM Interface for details.
    Dump/load procedures are located at 36.16.4 in the Windows interface and at 36.16.3 for UNIX environments. Load procedures do not overwrite existing records. You must delete the old data first.
    Note: Progress and Oracle each provide dump/load and import/export programs, but these programs do not maintain the integrity of data in the database. For information on Progress dump/load and bulk load programs, see the Progress user manuals.