<?xml version="1.0" encoding="utf-8"?>
<Session ID="/baanerp/bc/run/bcrun0103m000" xml:lang="en">
   <Header>
      <Title>Load Without Dumping (bcrun0103m000)</Title>
   </Header>
   <HelpTopic>
      <AimSection>
         <Paragraph>Use this session to load the data on the
		  target server. This session can be used in the following two
		  situations:</Paragraph>
         <List>
            <ListItem>If the source and the target environments are present on two
			 separate servers without a ERP client-server connection and the data files
			 after copying them manually to the target environment server, needs to be
			 loaded into the target database tables.</ListItem>
            <ListItem>If you need to reload all or some of the data from the data
			 files into the target database tables.</ListItem>
         </List>
         <Paragraph>When the session starts, all the fields are filled with the
		  values provided in the <GUIRef href="" role="manual">Conversion Parameters</GUIRef> (bcgct0100m000)
		  session, except for the following fields:</Paragraph>
      </AimSection>
      <GeneralSection>
         <SectionTitle>Process logic</SectionTitle>
         <ProcedureList>
            <ListItem>After entering the details, click <GUIRef href="" role="manual">OK</GUIRef> to
			 start the loading process. The user authentication dialog box appears. Enter
			 your personal conversion username and password for the authentication.</ListItem>
            <ListItem>Once you enter the correct user name and password, a dialog
			 box appears to confirm the starting of the process . Click <GUIRef href="" role="manual">Yes</GUIRef> to start the load data only process, or click <GUIRef href="" role="manual">No</GUIRef> to terminate
			 the load data only process.</ListItem>
            <ListItem>After you start the load data only process, the <GUIRef href="" role="manual">Filling bccnv400/401/402 tables</GUIRef> dialog box appears. Click <GUIRef href="" role="manual">Stop</GUIRef> to stop the load data only process.</ListItem>
            <ListItem>You have the flexibility to load tables in a particular
			 range, or a particular table. Make the selection by package, by module, or by a
			 table using <GUIRef href="" role="manual">Select Table Range for Load Only without Dumping</GUIRef> (bccnv0205m000) session.</ListItem>
            <ListItem>After the selection is complete, the system scans for the
			 tables that can be loaded in the range specified.</ListItem>
            <ListItem>After that, the data loading process starts and the Loading
			 data into the target environment session appears with the progress bar.</ListItem>
         </ProcedureList>
         <Note>
            <SectionTitle>Note</SectionTitle>
            <Paragraph>The progress bar does not represent the progress of the
			 loading process in terms of volume of data loaded but indicates the progress
			 based on the number of tables loaded so far.</Paragraph>
            <Paragraph>After the loading process is finished, Loading Complete
			 message box appears.</Paragraph>
            <Paragraph>The control files (.ctl) are required to provide the input
			 to the native Database Loader in case of Oracle database, about the format of
			 the .dat file from which the data needs to be picked up and loaded into the
			 specific target tables.</Paragraph>
         </Note>
      </GeneralSection>
      <GeneralSection>
         <Paragraph>Type of files generated by the <GUIRef href="" role="manual">Load Without Dumping</GUIRef> (bcrun0103m000) session:</Paragraph>
         <List>
            <ListItem>
               <GUIRef href="" role="manual">Log files</GUIRef> 
               <GUIRef href="" role="manual">:</GUIRef> The log files
			 (.log) are created by the native Database Loader for every non empty data file
			 in case of the Oracle database, indicating the result of data loading process
			 from the data files (.dat). The log files (.log) are created in the same
			 directory where the data files are located. After executing the Load Without
			 Dumping (bcrun0103m000) session, log files (.log) must be checked to analyze
			 the reason behind failure to load the data if the bad files (.bad) exist. Using
			 the log file, you can determine the number of rows successfully loaded for a
			 particular table, number of rows not loaded due to data errors and so on. In
			 case there are any rows not loaded due to data errors then the reason behind
			 the failure is also present in the log file and the rejected row(s) data is
			 present in the bad file.</ListItem>
            <ListItem>
               <GUIRef href="" role="manual">Bad files</GUIRef> 
               <GUIRef href="" role="manual">:</GUIRef> The bad files
			 (.bad) are created by the Oracle and MSSQL Server native Data Loader in the
			 same directory where the data files are located to specify the records that
			 were rejected due to data errors. These files are created with the name
			 &lt;Target tablename&gt;.bad.</ListItem>
            <ListItem>
               <GUIRef href="" role="manual">Reject Files</GUIRef> 
               <GUIRef href="" role="manual">:</GUIRef> These files
			 are created by the Informix Database Loader utility in the same directory where
			 the data files are located to specify which records were rejected due to data
			 errors. This file contains the records that were rejected due to data errors.
			 These files are created with the name &lt;Target tablename&gt;.rej.</ListItem>
         </List>
      </GeneralSection>
      <RelatedTopics>
         <SectionTitle>Related topics</SectionTitle>
         <RelTopic>
            <GUIRef href="/baanerp/bc/gct/bcgct8188m000" role="session">Maintain Batch Codes (bcgct8188m000)</GUIRef>
         </RelTopic>
         <RelTopic>
            <GUIRef href="/baanerp/bc/gct/bcgct0100m000" role="session">Conversion Parameters (bcgct0100m000)</GUIRef>
         </RelTopic>
         <RelTopic>
            <GUIRef href="/baanerp/bc/gct/bcgct8189m000" role="session">Tables By Batches (bcgct8189m000)</GUIRef>
         </RelTopic>
      </RelatedTopics>
   </HelpTopic>
   <Fields>
      <FieldHelp ID="bcgct003.comp">
         <Header>
            <Title>Company Number</Title>
         </Header>
         <FuncDesc>The target company into which the data must be
		  loaded.</FuncDesc>
      </FieldHelp>
      <FieldHelp ID="bcgct003.idpl">
         <Header>
            <Title>Use Database Independent Loaders?</Title>
         </Header>
         <FuncDesc>Please refer to <GUIRef href="/baanerp/bc/gct/bcgct0100m000#bcgct000.idpl" role="manual">Use Database Independent Loaders?</GUIRef> in <GUIRef href="" role="manual">Conversion Parameters</GUIRef> (bcgct0100m000) session.</FuncDesc>
      </FieldHelp>
      <FieldHelp ID="bcgct003.dbse">
         <Header>
            <Title>DBMS</Title>
         </Header>
         <FuncDesc>Please refer to <GUIRef href="/baanerp/bc/gct/bcgct0100m000#bcgct000.dbse" role="manual">RDBMS</GUIRef> in <GUIRef href="" role="manual">Conversion Parameters</GUIRef> (bcgct0100m000) session.</FuncDesc>
      </FieldHelp>
      <FieldHelp ID="bcgct003.para">
         <Header>
            <Title>Data Base Home &amp; SID</Title>
         </Header>
         <FuncDesc>Please refer to <GUIRef href="/baanerp/bc/gct/bcgct0100m000#bcgct000.para" role="manual">Data Base Home &amp; SID</GUIRef> in <GUIRef href="" role="manual">Conversion Parameters</GUIRef> (bcgct0100m000) session.</FuncDesc>
      </FieldHelp>
      <FieldHelp ID="bcgct003.datb">
         <Header>
            <Title>Database</Title>
         </Header>
         <FuncDesc>Please refer to <GUIRef href="/baanerp/bc/gct/bcgct0100m000#bcgct000.datb" role="manual">Database</GUIRef> in <GUIRef href="" role="manual">Conversion Parameters</GUIRef> (bcgct0100m000) session.</FuncDesc>
      </FieldHelp>
      <FieldHelp ID="bcgct003.serv">
         <Header>
            <Title>Server</Title>
         </Header>
         <FuncDesc>Please refer to <GUIRef href="/baanerp/bc/gct/bcgct0100m000#bcgct000.serv" role="manual">Server</GUIRef> in <GUIRef href="" role="manual">Conversion Parameters</GUIRef> (bcgct0100m000) session.</FuncDesc>
      </FieldHelp>
      <FieldHelp ID="bcgct003.dirc">
         <Header>
            <Title>Log File Path</Title>
         </Header>
         <FuncDesc>Please refer to <GUIRef href="/baanerp/bc/gct/bcgct0100m000#bcgct000.dirc" role="manual">Log File Path</GUIRef> in <GUIRef href="" role="manual">Conversion Parameters</GUIRef> (bcgct0100m000)
		  session.</FuncDesc>
      </FieldHelp>
      <FieldHelp ID="bcgct003.usrn">
         <Header>
            <Title>User Name of Loader</Title>
         </Header>
         <FuncDesc>Please refer to <GUIRef href="/baanerp/bc/gct/bcgct0100m000#bcgct000.usrn" role="manual">Username for Loader</GUIRef> in <GUIRef href="" role="manual">Conversion Parameters</GUIRef> (bcgct0100m000) session.</FuncDesc>
      </FieldHelp>
      <FieldHelp ID="bcgct003.merr">
         <Header>
            <Title>Max Rejections</Title>
         </Header>
         <FuncDesc>The value entered here is used during loading. While loading a
		  table, if the errors encountered are equal to the value entered here then the
		  loading of the table will be terminated. The process of loading continues with
		  the next table available.</FuncDesc>
      </FieldHelp>
      <FieldHelp ID="bcgct003.pswd">
         <Header>
            <Title>Pass Word of Loader</Title>
         </Header>
         <FuncDesc>Please refer to <GUIRef href="/baanerp/bc/gct/bcgct0100m000#bcgct000.pswd" role="manual">Password for Loader</GUIRef> in <GUIRef href="" role="manual">Conversion Parameters</GUIRef> (bcgct0100m000) session.</FuncDesc>
      </FieldHelp>
      <FieldHelp ID="bcgct003.pats">
         <Header>
            <Title>Path of Data Files</Title>
         </Header>
         <FuncDesc>Enter the path where the data files are located.</FuncDesc>
      </FieldHelp>
      <FieldHelp ID="bcgct000.dfmt">
         <Header>
            <Title>Date Format</Title>
         </Header>
         <FuncDesc>This field is applicable only if the target ERP database is
		  Oracle. While creating the data files in Source ERP Environment, a file
		  'dateformat' is created, which stores the date format in which data is written
		  to the data files. In the absence of that file, the format specified in the
		  field is considered for generating Oracle Control files for loading.</FuncDesc>
      </FieldHelp>
      <FieldHelp ID="bcgct003.scmp">
         <Header>
            <Title>Company of ManmanHP Data</Title>
         </Header>
         <FuncDesc>Current company at the source environment side.</FuncDesc>
      </FieldHelp>
      <FieldHelp ID="bcgct003.emmc">
         <Header>
            <Title>Company in which EMM data is stored</Title>
         </Header>
         <FuncDesc>The Enterprise Modelling data for all the companies can be
		  present in a single company at the target side. The company in which this data
		  is stored must be specified in this field. While migrating the source data, the
		  EMM data is loaded into the tables of that company.</FuncDesc>
         <SimpleSection>
            <Paragraph>same</Paragraph>
         </SimpleSection>
      </FieldHelp>
      <FieldHelp ID="bcgct003.btch">
         <Header>
            <Title>Batch Code</Title>
         </Header>
         <FuncDesc>The batch code for which you selected <GUIRef href="" role="manual">Load Without Dumping</GUIRef> option in <GUIRef href="" role="manual">Maintain Batch Codes</GUIRef> (bcgct8188m000) session is displayed.</FuncDesc>
         <SimpleSection>
            <Paragraph>Only the table information maintained using <GUIRef href="" role="manual">Tables by Batches</GUIRef> (bcgct8189m000) session for the selected batch code will be
			 considered while performing the loading activity.</Paragraph>
         </SimpleSection>
      </FieldHelp>
      <FieldHelp ID="bcgct003.stor">
         <Header>
            <Title>Store Conversion Run details?</Title>
         </Header>
         <FuncDesc>If this check box is selected, the conversion run details such as number of
		  records at every conversion phase, time taken for dumping and loading process
		  are stored.</FuncDesc>
      </FieldHelp>
      <FieldHelp ID="bcgct003.runo">
         <Header>
            <Title>Run Number</Title>
         </Header>
         <FuncDesc>Select the run number from <GUIRef href="" role="manual">Conversion Run Numbers</GUIRef> (bcgct1550m000) zoom-in session where the conversion run
		  details are to be maintained.</FuncDesc>
      </FieldHelp>
      <FieldHelp ID="bcgct003.time">
         <Header>
            <Title>Dump&amp;Load Time</Title>
         </Header>
         <FuncDesc>Select this check box if you want to maintain time taken for
		  dumping and loading process.</FuncDesc>
      </FieldHelp>
      <FieldHelp ID="bcgct003.coun">
         <Header>
            <Title>Count records after conversion?</Title>
         </Header>
         <FuncDesc>Please refer to <GUIRef href="/baanerp/bc/gct/bcgct0100m000#bcgct000.coun" role="manual">Count records after conversion?</GUIRef> in <GUIRef href="" role="manual">Conversion Parameters</GUIRef> (bcgct0100m000) session.</FuncDesc>
      </FieldHelp>
   </Fields>
</Session>