<?xml version="1.0" encoding="utf-8"?>
<Session ID="/baanerp/bc/run/bcrun0207m000" xml:lang="en">
	<Header>
		<Title xmlns:ssa="http://www.ssaglobal.com" xmlns:HTML="http://www.w3.org/TR/REC-html40">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 xmlns:ssa="http://www.ssaglobal.com" xmlns:HTML="http://www.w3.org/TR/REC-html40">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 xmlns:ssa="http://www.ssaglobal.com" xmlns:HTML="http://www.w3.org/TR/REC-html40">Continue</Title>
			</Header>
			<FuncDesc>Click <GUIRef href="" role="manual">Continue</GUIRef> to start populating the onpload database.</FuncDesc>
		</CommandHelp>
	</FormCommands>
</Session>
