This chapter describes how to use programs to manage the movement and storage of data in a database.
Explains how the CIM interface is used to transfer data in and out of a QAD database.
Using the CIM Interface
Explains how to use the CIM interface and gives details on CIM data formats, input file formatting rules, input data types, determining data for input files, a CIM data input file example, creating a CIM input file, and error handling.
Deleting Records through CIM
Lists programs with the batchdelete functionality and discusses creating input files to delete records, and gives an example of CIM delete.
Running Multiple CIM Sessions
Explains how to run multiple CIM sessions for different files.
Killing CIM Sessions
Explains the best way to kill a CIM session.
Transferring data can save disk space, increase disk access speeds by compacting fragmented data, and integrate legacy or otherwise noncompatible data with QAD data. There are three basic ways to transfer data into and out of your QAD database:
Dump or load data files.
Archive and delete or reload data files.
The first two options are discussed in this topic
. This chapter discusses CIM data load, which lets you load data into the system from any source, as long as the data is formatted to match the schema.
CIM is typically used to add or modify records in a database. In certain cases, it can also be used to delete records. Only some functions support this feature.
Unlike direct data loads, CIM checks load data for errors and saves unloaded records in an error file for correction and reloading. CIM loads can be run in either batch or continuous mode.
Note: QXtend offers more features for data transfer. See Data Synchronization in User Guide: QAD QXtend.