<?xml version="1.0" encoding="utf-8"?>
<Session ID="/baanerp/bc/gct/bcgct8189m000" xml:lang="en">
   <Header>
      <Title>Tables By Batches (bcgct8189m000)</Title>
   </Header>
   <HelpTopic>
      <AimSection>
         <Paragraph>Use this session to list the tables under a
		  specific batch along with further information regarding the migration of each
		  table.</Paragraph>
      </AimSection>
      <GeneralSection>
         <SectionTitle>Preparation</SectionTitle>
         <Paragraph>Before you can use this session, the <GUIRef href="" role="manual">Maintain Batch Codes</GUIRef> (bcgct8188m000) session should be running. The <GUIRef href="" role="manual">Tables By Batches</GUIRef> (bcgct8189m000) session can be invoked from
		  the <GUIRef href="" role="manual">Maintain Batch Codes</GUIRef> session.</Paragraph>
      </GeneralSection>
      <RelatedTopics>
         <SectionTitle>Related topics</SectionTitle>
         <RelTopic>
            <GUIRef href="/baanerp/bc/gct/bcgct8188m000" role="session">Maintain Batch Codes (bcgct8188m000)</GUIRef>
         </RelTopic>
      </RelatedTopics>
   </HelpTopic>
   <Fields>
      <FieldHelp ID="bcgct889.btch">
         <Header>
            <Title>Batch Code</Title>
         </Header>
         <FuncDesc>This field displays the <GUIRef href="" role="manual">Batch Code</GUIRef> from which
		  the tables are listed.</FuncDesc>
      </FieldHelp>
      <FieldHelp ID="bcgct889.tabl">
         <Header>
            <Title>Table Name</Title>
         </Header>
         <FuncDesc>This field displays the name of the table.</FuncDesc>
      </FieldHelp>
      <FieldHelp ID="bcgct889.byps">
         <Header>
            <Title>Skip?</Title>
         </Header>
         <FuncDesc>The value in this field indicates whether the table is
		  considered for migration or not.</FuncDesc>
         <SimpleSection>
            <Paragraph>If this check box is selected, the table is bypassed during conversion that
			 is, the table is not considered for migration. If this check box is cleared, the table is considered for
			 migration.</Paragraph>
         </SimpleSection>
      </FieldHelp>
      <FieldHelp ID="bcgct889.durn">
         <Header>
            <Title>Duration</Title>
         </Header>
         <FuncDesc>The value in this field indicates the time taken for migrating
		  the table.</FuncDesc>
         <AllowedValues>
            <SectionTitle>Allowed values</SectionTitle>
            <List>
               <ListItem>
                  <GUIRef href="" role="manual">Shorter</GUIRef>
               </ListItem>
               <ListItem>
                  <GUIRef href="" role="manual">Longer</GUIRef>
               </ListItem>
            </List>
         </AllowedValues>
         <DefaultValue>
            <SectionTitle>Default value</SectionTitle>
            <List>
               <ListItem>
                  <GUIRef href="" role="manual">Shorter</GUIRef>
               </ListItem>
            </List>
         </DefaultValue>
         <SimpleSection>
            <Paragraph>Select <GUIRef href="" role="manual">Longer</GUIRef> if the table is extremely
			 large. While dumping, all the tables marked as <GUIRef href="" role="manual">Longer</GUIRef> are
			 dumped first, followed by tables marked as <GUIRef href="" role="manual">Shorter</GUIRef>. This helps
			 in load balancing, and ensures that dumping the large tables does not start at
			 the end and take a long time when all the other b-shells are already completing
			 the dumping process. A list of tables that usually contain a large amount of
			 data are marked as <GUIRef href="" role="manual">Longer</GUIRef>. You can choose a list of tables
			 manually, as per your requirements.</Paragraph>
            <List>
               <ListItem>Load balancing is a technique used to improve the
				performance of the tool.</ListItem>
               <ListItem>Generate a mix of <GUIRef href="" role="manual">Longer</GUIRef> and <GUIRef href="" role="manual">Shorter</GUIRef> tables in a ratio of 60:40 for the dump b-shells.</ListItem>
            </List>
         </SimpleSection>
      </FieldHelp>
      <FieldHelp ID="bcgct889.mode">
         <Header>
            <Title>Load Option</Title>
         </Header>
         <FuncDesc>The value in this field indicates, if data is already existing,
		  the same must be overwritten or retained during migration.</FuncDesc>
         <AllowedValues>
            <SectionTitle>Allowed values</SectionTitle>
            <List>
               <ListItem>
                  <GUIRef href="" role="manual">Truncate</GUIRef>: If the table on the target side
				already has some data, the data will be deleted and data from the table on the
				source side will be added to the table on the target side during migration.</ListItem>
               <ListItem>
                  <GUIRef href="" role="manual">Append</GUIRef>: The data from the table on the
				source side is appended to the already existing data in the table on the target
				side.</ListItem>
            </List>
         </AllowedValues>
         <DefaultValue>
            <SectionTitle>Default value</SectionTitle>
            <List>
               <ListItem>
                  <GUIRef href="" role="manual">Truncate</GUIRef>
               </ListItem>
            </List>
         </DefaultValue>
         <SimpleSection>
            <Paragraph>The <GUIRef href="" role="manual">Truncate</GUIRef> option is not available in the
			 Informix-specific loader. If the load option is <GUIRef href="" role="manual">Truncate</GUIRef>, the
			 table rows are manually deleted with SQL, and the <GUIRef href="" role="manual">Append</GUIRef> option is the default option.</Paragraph>
         </SimpleSection>
      </FieldHelp>
      <FieldHelp ID="bcgct889.load">
         <Header>
            <Title>Mode of Loading</Title>
         </Header>
         <FuncDesc>The value in this field is used during the generation of the
		  control file.</FuncDesc>
         <AllowedValues>
            <SectionTitle>Allowed values</SectionTitle>
            <List>
               <ListItem>
                  <GUIRef href="" role="manual">Automatic</GUIRef>
               </ListItem>
               <ListItem>
                  <GUIRef href="" role="manual">Conventional</GUIRef>
               </ListItem>
            </List>
         </AllowedValues>
         <DefaultValue>
            <SectionTitle>Default value</SectionTitle>
            <List>
               <ListItem>
                  <GUIRef href="" role="manual">Automatic</GUIRef>
               </ListItem>
            </List>
         </DefaultValue>
         <SimpleSection>
            <Paragraph>The Oracle SQL* Loader has two load modes. The two modes
			 are Direct and Conventional. If you set the load mode to <GUIRef href="" role="manual">Automatic</GUIRef>, and the size of the data file is greater than
			 10,000 bytes, the load mode of SQL* Loader is set to Direct. If you set the
			 load mode to <GUIRef href="" role="manual">Conventional</GUIRef>, the load mode of SQL* Loader is
			 also set to Conventional.</Paragraph>
            <Paragraph>Informix HPL has two load modes. The two modes are Express
			 and Deluxe. If you set the load mode in Informix to <GUIRef href="" role="manual">Automatic</GUIRef>,
			 and the size of the data file is greater than 10,000 bytes, the load mode of
			 Informix HPL is set to Express. Otherwise, the load mode is Deluxe. If you set
			 the load mode to <GUIRef href="" role="manual">Conventional</GUIRef>, the load mode of the Informix
			 HPL is set to Deluxe.</Paragraph>
         </SimpleSection>
      </FieldHelp>
      <FieldHelp ID="bcgct889.obje">
         <Header>
            <Title>Object Present</Title>
         </Header>
         <FuncDesc>The value in this field indicates whether the conversion script
		  (in the form of dll) is present for the respective table on the source side or
		  not.</FuncDesc>
      </FieldHelp>
   </Fields>
   <FormCommands>
      <CommandHelp ID="bcgct8289m000">
         <Header>
            <Title>Generate</Title>
         </Header>
         <FuncDesc>Use this option in the <Link href="/baanerp/tc/glossary/glossary#specific" role="glossary">appropriate</Link> menu to generate the list of
		  tables under a batch.</FuncDesc>
         <SimpleSection>
            <Paragraph>It starts the <GUIRef href="" role="manual">Generate</GUIRef> (bcgct8289m000)
			 session. Specify the range for package, module and table. For the given range,
			 it checks if every package is implemented in <GUIRef href="" role="manual">Implemented Packages</GUIRef> (bcgct7187m000) session.</Paragraph>
            <Paragraph>If the <GUIRef href="" role="manual">Tables by Batches</GUIRef> (bcgct8189m000)
			 session already consists of table related data for the currently selected batch
			 code, you will be shown a message box with the query <GUIRef href="" role="manual">Do you want to delete the existing methods and generate afresh?</GUIRef>. The message box
			 provides the following options:</Paragraph>
            <List>
               <ListItem>
                  <GUIRef href="" role="manual">Append</GUIRef>: Adds the generated data to the
				existing data in <GUIRef href="" role="manual">Tables by Batches</GUIRef> (bcgct8189m000) session.</ListItem>
               <ListItem>
                  <GUIRef href="" role="manual">Overwrite</GUIRef>: Deletes the existing data and
				store only the generated data in <GUIRef href="" role="manual">Tables by Batches</GUIRef> (bcgct8189m000) session.</ListItem>
               <ListItem>
                  <GUIRef href="" role="manual">Cancel</GUIRef>: Cancels the action.</ListItem>
            </List>
         </SimpleSection>
      </CommandHelp>
      <CommandHelp ID="bcgct8489m000">
         <Header>
            <Title>Print Verify List</Title>
         </Header>
         <FuncDesc>Use this option in the <Link href="/baanerp/tc/glossary/glossary#specific" role="glossary">appropriate</Link> menu to print a report. This
		  report displays the list of tables that are currently present in the <GUIRef href="" role="manual">Tables by Batches</GUIRef> (bcgct8189m000) session.</FuncDesc>
      </CommandHelp>
      <CommandHelp ID="bcgct9285m000">
         <Header>
            <Title>Set Bypass Yes/No to Range of Tables</Title>
         </Header>
         <FuncDesc>Use this option in the <Link href="/baanerp/tc/glossary/glossary#specific" role="glossary">appropriate</Link> menu to update the value in
		  the <GUIRef href="" role="manual">Bypass</GUIRef> field for a range of tables
		  simultaneously.</FuncDesc>
      </CommandHelp>
   </FormCommands>
</Session>