Generate Onpload Database (bcrun0207m000)
Use this session to fill up the onpload database with the information that the onpload utility requires to perform the data loading for informix database only.
Preparation
If you are carrying out the conversion process for the first time, then you must create an Onpload database and execute a SQL script (which comes along with the onpload utility) to create objects in that database before executing this session. For more information, refer to Informix Technical Manuals.
If you are not carrying out the Conversion process for the first time, then you must remove all the data from the tables given below, before executing this session:
- Formatitem
- Formats
- Maps
- Mapitem
- Session
- Mapoption
Execution
This session is to be executed only if you are using Informix database at the target side.
The onpload database can reside on any database server on your network. In addition, any onpload utility can use the onpload database as long as the onpload utility can access the database server that contains the onpload database. In contrast, the onpload utility must run on the same computer as the database server that contains the target database.
Process logic
To populate the onpload database with the table mapping information (similar to control files in Oracle), SQL scripts are used. These scripts are generated according to the target table structures. After you click Generate onpload for multi company (informix) (bccnv0507m000) session or after you click in the Generate Onpload Database (bcrun0207m000) session, the process of populating the onpload database begins.
in theThe generated SQL scripts are used for populating the data in the following tables of onpload database.
- Formats
- Formatitem
- Maps
- Mapitem
- Session
- Mapoption
- Multiple Company Conversion Yes/No
-
Use this field to specify if the conversion carried out is for multiple company or single company.
If this check box is selected, the conversion is carried out for multiple company. If this check box is cleared, the conversion is carried out for a single company.
The Generate onpload for multi company (Informix) (bcrun0507m000) session appears if you are carrying out multiple company conversion. Check the company numbers of which you want to convert the data and then click .