<?xml version="1.0" encoding="utf-8"?>
<Session ID="/baanerp/bc/run/bcrun0207m000" xml:lang="en">
   <Header>
      <Title>Generate Onpload Database (bcrun0207m000)</Title>
   </Header>
   <HelpTopic>
      <AimSection>
         <Paragraph>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.</Paragraph>
      </AimSection>
      <GeneralSection>
         <SectionTitle>Preparation</SectionTitle>
         <Paragraph>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.</Paragraph>
         <Paragraph>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:</Paragraph>
         <List>
            <ListItem>Formatitem</ListItem>
            <ListItem>Formats</ListItem>
            <ListItem>Maps</ListItem>
            <ListItem>Mapitem</ListItem>
            <ListItem>Session</ListItem>
            <ListItem>Mapoption</ListItem>
         </List>
      </GeneralSection>
      <GeneralSection>
         <SectionTitle>Execution</SectionTitle>
         <Paragraph>This session is to be executed only if you are using Informix
		  database at the target side.</Paragraph>
         <Paragraph>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.</Paragraph>
      </GeneralSection>
      <GeneralSection>
         <SectionTitle>Process logic</SectionTitle>
         <Paragraph>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 <GUIRef href="" role="manual">Generate</GUIRef> in the <GUIRef href="" role="manual">Generate onpload for multi company (informix)</GUIRef> (bccnv0507m000) session or after you click <GUIRef href="" role="manual">Continue</GUIRef> in the <GUIRef href="" role="manual">Generate Onpload Database</GUIRef> (bcrun0207m000) session, the process of populating the onpload database
		  begins.</Paragraph>
         <Note>
            <SectionTitle>Note</SectionTitle>
            <Paragraph>For Informix, as the <GUIRef href="" role="manual">Truncate</GUIRef> load option
			 is not available in Informix HPL, the <GUIRef href="" role="manual">Generate Onpload Database</GUIRef> (bcrun0207m000) session deletes the table data for the tables
			 having truncate option set.</Paragraph>
         </Note>
         <Paragraph>The generated SQL scripts are used for populating the data in
		  the following tables of onpload database.</Paragraph>
         <List>
            <ListItem>Formats</ListItem>
            <ListItem>Formatitem</ListItem>
            <ListItem>Maps</ListItem>
            <ListItem>Mapitem</ListItem>
            <ListItem>Session</ListItem>
            <ListItem>Mapoption</ListItem>
         </List>
      </GeneralSection>
      <RelatedTopics>
         <SectionTitle>Related topics</SectionTitle>
         <RelTopic>
            <GUIRef href="/baanerp/bc/run/bcrun0507m000" role="session">Generate onpload for multi company(informix) (bcrun0507m000)</GUIRef>
         </RelTopic>
      </RelatedTopics>
   </HelpTopic>
   <Fields>
      <FieldHelp ID="ynmc">
         <Header>
            <Title>Multiple Company Conversion Yes/No</Title>
         </Header>
         <FuncDesc>Use this field to specify if the conversion carried out is for
		  multiple company or single company.</FuncDesc>
         <SimpleSection>
            <Paragraph>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.</Paragraph>
            <Paragraph>The <GUIRef href="" role="manual">Generate onpload for multi company (Informix)</GUIRef> (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 <GUIRef href="" role="manual">Generate</GUIRef>.</Paragraph>
         </SimpleSection>
      </FieldHelp>
   </Fields>
   <FormCommands>
      <CommandHelp ID="exec.cont.process">
         <Header>
            <Title>Continue</Title>
         </Header>
         <FuncDesc>Click <GUIRef href="" role="manual">Continue</GUIRef> to start populating the onpload
		  database.</FuncDesc>
      </CommandHelp>
   </FormCommands>
</Session>