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 in the Generate onpload for multi company (informix) (bccnv0507m000) session or after you click Continue in the Generate Onpload Database (bcrun0207m000) session, the process of populating the onpload database begins.

Note: For Informix, as the Truncate load option is not available in Informix HPL, the Generate Onpload Database (bcrun0207m000) session deletes the table data for the tables having truncate option set.

The 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 Generate.