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  |   On Demand  |   Home  |   qad.com




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.