<?xml version="1.0" encoding="utf-8"?>
<Session ID="/baanerp/tt/aad/ttaad4227m000" xml:lang="en">
	<Header>
		<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Create Table from Sequential Dump (ttaad4227m000)</Title>
	</Header>
	<HelpTopic xml:lang="en"><AimSection><Paragraph class="Default"> 
                                 Use this session to import data from sequential files, created by the <GUIRef href="/baanerp/tt/aad/ttaad4226m000" role="session">Create Sequential Dump of Table (ttaad4226m000)</GUIRef> session, into ERP LN database tables.</Paragraph>
		</AimSection>
		<GeneralSection><Paragraph class="Default">The session can append data to existing database tables, or create new database tables based on the information in the sequential files.</Paragraph>
			<List><ListIntro>The session offers many features, for example:</ListIntro>
				<ListItem>it creates the database tables if they do not exist.</ListItem>
				<ListItem>it compares the current <Link href="/baanerp/tt/glossary/glossary#100005" role="glossary">data dictionary</Link> information with the information in the dump. If the information does not match, an error message is shown. If the current data dictionary is not present the session creates one based on the dump, for example dtccom/dtccom001.</ListItem>
			</List>
		</GeneralSection>
		<GeneralSection><SectionTitle>Session usage</SectionTitle>
			<List><ListIntro>To import data:</ListIntro>
				<ListItem>Select the company into which the content of the sequential files must be imported.</ListItem>
				<ListItem>Use the remaining fields and check boxes to specify the settings for the import process. Refer to the online field help for details.</ListItem>
				<ListItem>Click <GUIRef href="" role="manual">Create</GUIRef>.</ListItem>
			</List>
			<Note><SectionTitle>
                                    Note
                                 </SectionTitle>
				<List><ListItem>Use this session only if the sequential files are created through the <GUIRef href="/baanerp/tt/aad/ttaad4226m000" role="session">Create Sequential Dump of Table (ttaad4226m000)</GUIRef> session. This session cannot import manually converted data.</ListItem>
					<ListItem>If you import data with the <GUIRef href="/baanerp/tt/aad/ttaad4227m000#igri.yeno" role="manual">Ignore Referential Integrity Constraints</GUIRef> check box selected, you must run the <GUIRef href="/baanerp/tt/aad/ttaad4225m000" role="session">Reorganize Tables (ttaad4225m000)</GUIRef> session afterwards, with the <GUIRef href="/baanerp/tt/aad/ttaad4225m000#rcnt.yeno" role="manual">Repair Reference Counter</GUIRef> check box selected.</ListItem>
				</List>
			</Note>
		</GeneralSection>
		<GeneralSection><SectionTitle>Sequential file types</SectionTitle>
			<List><ListIntro>You can import data from:</ListIntro>
				<ListItem>sequential files with a field separator. To use this option, select the <GUIRef href="/baanerp/tt/aad/ttaad4227m000#fsep.yeno" role="manual">Specify Field Separators of Seq File</GUIRef> check box and specify the separator in the <GUIRef href="/baanerp/tt/aad/ttaad4227m000#sepa" role="manual">Specify Field Separators of Seq File</GUIRef> field.</ListItem>
				<ListItem>sequential files with a fixed record length. To use this option, select the <GUIRef href="/baanerp/tt/aad/ttaad4227m000#fixl.yeno" role="manual">Sequential File has Fixed Record Length</GUIRef> check box.</ListItem>
				<ListItem>a sequential dump file containing the records and data dictionary information of multiple tables. To use this option, enter the name of the dump file in the <GUIRef href="/baanerp/tt/aad/ttaad4227m000#flnm" role="manual">Name of the Dump File</GUIRef> field.</ListItem>
			</List>
			<Paragraph class="Default">All these files are created through the <GUIRef href="/baanerp/tt/aad/ttaad4226m000" role="session">Create Sequential Dump of Table (ttaad4226m000)</GUIRef> session.</Paragraph>
		</GeneralSection>
		<GeneralSection ID="load_from_other_company"><SectionTitle>Load data from another company</SectionTitle>
			<Paragraph class="Default">If you want to import data that was exported from another company, you must first correct the company numbers in the sequential files: the extracted data in the sequential files contains references to the source company number. Before loading the data into the target company, you must run the <GUIRef href="/baanerp/tc/com/tccom0214m000" role="session">Copy Company Data (tccom0214m000)</GUIRef> session to correct these references, so that they refer to the target company. This session can only handle files with a field separator.</Paragraph>
			<Paragraph class="Default">Therefore, to extract the data from the source company, you must run the <GUIRef href="/baanerp/tt/aad/ttaad4226m000" role="session">Create Sequential Dump of Table (ttaad4226m000)</GUIRef> session with the <GUIRef href="/baanerp/tt/aad/ttaad4226m000#fsep.yeno" role="manual">Specify Field Separators</GUIRef> check box selected.</Paragraph>
			<Paragraph class="Default">Refer to <Link href="/baanerp/tt/onlinemanual/100140a" role="manual">To copy a multicompany structure - Procedure details</Link> for more information.</Paragraph>
		</GeneralSection>
		<GeneralSection><SectionTitle>Technical information</SectionTitle>
			<Paragraph class="Default">Internally the session uses the bdbpost6.2 executable. For more information on this executable, refer to the <DocRef>Infor Enterprise Server 8.5 Technical Manual (U8172 US)</DocRef>.</Paragraph>
		</GeneralSection>
		<RelatedTopics><SectionTitle>
                                 Related topics
                              </SectionTitle>
			<RelTopic><Link href="/baanerp/basictasks/000005" role="manual">To use a details session</Link>
			</RelTopic>
		</RelatedTopics>
	</HelpTopic>
	<Fields><FieldHelp ID="dfco.yeno"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Create Tables for Different Company</Title>
			</Header>
			<FuncDesc> 
                                 If this check box is selected, the content of the file(s) can be imported into a different company than the one from which they were exported. You must specify the target company in the <GUIRef href="/baanerp/tt/aad/ttaad4227m000#dfco" role="manual">Company</GUIRef> field.</FuncDesc>
			<SimpleSection><Paragraph class="Default">Before you import data into a different company, you must correct the company numbers in the sequential files. This is only possible if the files contain a field separator. Refer to <Link href="#load_from_other_company" role="internal">Load data from another company</Link> for details.</Paragraph>
				<Paragraph class="Default">
                                    If this check box is cleared, the content of the files is imported into the company they were exported from.</Paragraph>
			</SimpleSection>
		</FieldHelp>
		<FieldHelp ID="dfco"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Company</Title>
			</Header>
			<FuncDesc>The company number into which the content of the file(s) will be imported.</FuncDesc>
			<SimpleSection></SimpleSection>
			<Note><SectionTitle>
                                    Note
                                 </SectionTitle>
				<Paragraph class="Default">You can only specify a company number if the <GUIRef href="/baanerp/tt/aad/ttaad4227m000#dfco.yeno" role="manual">Create Tables for Different Company</GUIRef> check box is selected.</Paragraph>
			</Note>
		</FieldHelp>
		<FieldHelp ID="pacc"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Package Combination</Title>
			</Header>
			<FuncDesc>The <Link href="/baanerp/tt/glossary/glossary#000000000000012" role="glossary">package combination</Link> that belongs to the company into which you want to import the contents of the sequential files.</FuncDesc>
		</FieldHelp>
		<FieldHelp ID="apnd.yeno"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Append if Table Exists</Title>
			</Header>
			<FuncDesc> 
                                 If this check box is selected, the data from the sequential (dump) file is appended to existing tables in the selected company. If a particular table does not exist, it will be created automatically before the corresponding data is imported.</FuncDesc>
			<SimpleSection><Paragraph class="Default">
                                    If this check box is cleared, no data is imported into already existing tables. The import process only creates new tables and subsequently loads the corresponding data from the files.</Paragraph>
			</SimpleSection>
		</FieldHelp>
		<FieldHelp ID="ovwr.yeno"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Overwrite Duplicate Records from Dump</Title>
			</Header>
			<FuncDesc> 
                                 If this check box is selected, duplicate records are overwritten: if the file and the table contain records with identical key values, the records from the file will overwrite the corresponding duplicate records in the table.</FuncDesc>
			<SimpleSection><Paragraph class="Default"><GUIRef href="" role="manual">Example</GUIRef>
				</Paragraph>
				<Paragraph class="Default">The Item Groups (tcmc023) table and the corresponding sequential file both contain an Item Group record with Item Group Code "ABC". If this check box is selected, the record from the file will overwrite the record in the table.</Paragraph>
			</SimpleSection>
		</FieldHelp>
		<FieldHelp ID="dltb.yeno"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Delete Existing Tables</Title>
			</Header>
			<FuncDesc> 
                                 If this check box is selected, the tables already present are deleted before the new ones are created.</FuncDesc>
			<SimpleSection><Paragraph class="Default">You cannot use this option if the <GUIRef href="/baanerp/tt/aad/ttaad4227m000#apnd.yeno" role="manual">Append if Table Exists</GUIRef> check box is selected.</Paragraph>
				<Paragraph class="Default">
                                    If this check box is cleared, the existing tables are not deleted. Only new tables are created.</Paragraph>
			</SimpleSection>
		</FieldHelp>
		<FieldHelp ID="rbix.yeno"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Create Rows before Index</Title>
			</Header>
			<FuncDesc> 
                                 If this check box is selected, the tables are created by first inserting all rows and then creating the <Link href="/baanerp/tt/glossary/glossary#index.tt" role="glossary">indexes</Link>.</FuncDesc>
			<SimpleSection><List><ListIntro>By using this option the tables are created faster but a few things should be noted:</ListIntro>
					<ListItem>Interrupting the process results in table inconsistency</ListItem>
					<ListItem>An index cannot be created in case of a duplicate conflict</ListItem>
					<ListItem>For large tables, adding of indices can take a long time (&gt; 15 min)</ListItem>
				</List>
			</SimpleSection>
		</FieldHelp>
		<FieldHelp ID="ddmc.yeno"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Disable Domain Constraints</Title>
			</Header>
			<FuncDesc> 
                                 If this check box is selected, the domain constraints are disabled. There is no check to make sure that the data of a table field meets the requirements of the domain in the table definition.</FuncDesc>
			<SimpleSection><SectionTitle>
                                    Example
                                 </SectionTitle>
				<Paragraph class="Default">It is possible that a string of 30 characters is placed in a field with a string domain of only 15 characters. In that case you loose information. So take care when you select this check box.</Paragraph>
				<Paragraph class="Default">Normally the domains of the data in the sequential files must be identical to the domains in the environment into which the files are imported. In that case you must clear this check box. If the domains differ, you must select this check box.</Paragraph>
			</SimpleSection>
		</FieldHelp>
		<FieldHelp ID="igri.yeno"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Ignore Referential Integrity Constraints</Title>
			</Header>
			<FuncDesc> 
                                 If this check box is selected, the referential integrity constraints are ignored.</FuncDesc>
			<SimpleSection><Paragraph class="Default">It is possible that the tables created from the sequential files / dump have a reference to tables that will be created later from the same set of files or from the same dump. Because the latter tables do not exist yet, this can create a problem.</Paragraph>
				<Paragraph class="Default"><GUIRef href="" role="manual">Example:</GUIRef>
				</Paragraph>
				<Paragraph class="Default">The tccom001 (Employees - General) table contains a reference to the tcmcs046 (Languages) table. The import process creates the tables in alphabetical order. Therefore tccom001 is created before tcmcs046. The import of records in tccom001 fails because for each employee record, the corresponding Language record in tcmcs046 does not exist yet.</Paragraph>
				<Paragraph class="Default">You can ignore this type of referential integrity constraints by selecting this check box. In this way tables will be created and the import of data will succeed, despite the corresponding reference tables do not exist yet. Once all tables have been created from the sequential files / dump, you must run the <GUIRef href="/baanerp/tt/aad/ttaad4225m000" role="session">Reorganize Tables (ttaad4225m000)</GUIRef> session, with the <GUIRef href="/baanerp/tt/aad/ttaad4225m000#rcnt.yeno" role="manual">Repair Reference Counter</GUIRef> check box selected.</Paragraph>
				<Paragraph class="Default"><GUIRef href="" role="manual">Note</GUIRef>
				</Paragraph>
				<Paragraph class="Default">You can also overwrite data of existing tables, or create tables from the sequential files / dump which have a reference to existing tables in the environment where the tables are created. In that case, this check box must be cleared, because the reference tables are already present.</Paragraph>
			</SimpleSection>
		</FieldHelp>
		<FieldHelp ID="exlt.yeno"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Exclude Logical Tables From Dump</Title>
			</Header>
			<FuncDesc> 
                                 If this check box is selected, ERP LN does not import data into tables that are defined as "logical tables". For each logical table that is skipped, ERP LN writes a message to the "dump.err" output file.</FuncDesc>
			<SimpleSection><Paragraph class="Default">
                                    If this check box is cleared, ERP LN does not skip the import for logical tables. If a table is defined as a "logical table", ERP LN imports the data into the corresponding physical table, which is stored in a different company.</Paragraph>
				<Paragraph class="Default">For example: The Employees (tccom001) table in company 100 is a logical table. The corresponding physical table is stored in company 200. When you import employee data into company 100, the data is imported in the physical Employees (tccom001) table in company 200.</Paragraph>
			</SimpleSection>
			<Note><SectionTitle>
                                    Note
                                 </SectionTitle>
				<List><ListItem>To import data into a logical table, the corresponding physical table must exist. If the physical table does not exist, ERP LN cannot import the data, and therefore logs an error message.</ListItem>
					<ListItem>When you import data into logical tables through the bdbpost6.2 executable, errors are logged if bdbpost6.2 tries to delete the ‘old’ table, which is not physically available in the logical company. For more information on bdbpost6.2, refer to the <DocRef>Infor Enterprise Server 8.5 Technical Manual (U8172 US)</DocRef>.</ListItem>
					<ListItem>You can only clear this check box if the <GUIRef href="/baanerp/tt/aad/ttaad4227m000#apnd.yeno" role="manual">Append if Table Exists</GUIRef> check box is selected.</ListItem>
				</List>
			</Note>
		</FieldHelp>
		<FieldHelp ID="stid.yeno"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Set Timestamp to Import Date</Title>
			</Header>
			<FuncDesc>
                                 If this check box is selected, ERP LN updates all timestamp values of the rcd_utc column, if present, to the time the import is done.</FuncDesc>
			<SimpleSection><Paragraph class="Default">
                                    If this check box is cleared, ERP LN preserves the timestamp values of the rcd_utc column. This way a straightforward export/import is neutral with respect to the data stored in the table.</Paragraph>
			</SimpleSection>
		</FieldHelp>
		<FieldHelp ID="fsep.yeno"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Specify Field Separators of Seq File</Title>
			</Header>
			<FuncDesc>Select this check box if the sequential files contain a field separator. You must specify the separator in the next field.</FuncDesc>
			<SimpleSection><Paragraph class="Default">You must specify the directory where the sequential files are stored in the <GUIRef href="/baanerp/tt/aad/ttaad4227m000#table.dir" role="manual">Directory for Searching Table Files</GUIRef> field.</Paragraph>
				<Paragraph class="Default"><GUIRef href="" role="manual">Note</GUIRef>
				</Paragraph>
				<Paragraph class="Default">Files with a field separator are created through the <GUIRef href="/baanerp/tt/aad/ttaad4226m000" role="session">Create Sequential Dump of Table (ttaad4226m000)</GUIRef> session. A file with a .S extension is created for each of the selected tables. For example: the sequential file ttccom001550.S contains the data that is extracted from the tccom001 (Employees - General) table in company 550.</Paragraph>
			</SimpleSection>
		</FieldHelp>
		<FieldHelp ID="sepa"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Specify Field Separators of Seq File</Title>
			</Header>
			<FuncDesc>The field separator that is used in the sequential files: this is the same separator as the one that was specified during the export in the <GUIRef href="/baanerp/tt/aad/ttaad4226m000" role="session">Create Sequential Dump of Table (ttaad4226m000)</GUIRef> session.</FuncDesc>
		</FieldHelp>
		<FieldHelp ID="fixl.yeno"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Sequential File has Fixed Record Length</Title>
			</Header>
			<FuncDesc>Select this check box if you want to import data from sequential files with a fixed record length and without any separators.</FuncDesc>
			<SimpleSection><Paragraph class="Default"><GUIRef href="" role="manual">Note</GUIRef>
				</Paragraph>
				<Paragraph class="Default">Files with a fixed record length are created through the <GUIRef href="/baanerp/tt/aad/ttaad4226m000" role="session">Create Sequential Dump of Table (ttaad4226m000)</GUIRef> session. A file with a .F extension is created for each of the selected tables. For example: the sequential file ttccom001550.F contains the data that is extracted from the tccom001 (Employees - General) table in company 550.</Paragraph>
				<Paragraph class="Default">You must specify the directory where the sequential files are stored in the <GUIRef href="/baanerp/tt/aad/ttaad4227m000#table.dir" role="manual">Directory for Searching Table Files</GUIRef> field.</Paragraph>
				<Paragraph class="Default"><GUIRef href="" role="manual">Important:</GUIRef>
				</Paragraph>
				<Paragraph class="Default">Do not load files with a fixed record length into a different company than the one from which they were exported. Refer to <Link href="#load_from_other_company" role="internal">Load data from another company</Link> for details.</Paragraph>
			</SimpleSection>
		</FieldHelp>
		<FieldHelp ID="table.dir"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Directory for Searching Table Files</Title>
			</Header>
			<FuncDesc>The directory where the files with a fixed record length, or the files with a field separator, are stored.</FuncDesc>
		</FieldHelp>
		<FieldHelp ID="tpat"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Pattern to Match Table Names</Title>
			</Header>
			<FuncDesc>A sequential dump can contain the contents of many tables. Use this field to specify the name of the tables for which data will be loaded from the dump.</FuncDesc>
			<SimpleSection><List><ListIntro>You can use the following wildcards:</ListIntro>
					<ListItem>* : matches any string of characters</ListItem>
					<ListItem>?: matches any single character</ListItem>
				</List>
				<Paragraph class="Default"></Paragraph>
				<List><ListIntro>Examples:</ListIntro>
					<ListItem>Enter * to load data for all tables in the dump.</ListItem>
					<ListItem>Enter *tccom* to load data for tables of package tc, module com, only.</ListItem>
				</List>
			</SimpleSection>
			<DefaultValue><SectionTitle>
                                    Default value
                                 </SectionTitle>
				<Paragraph class="Default">*</Paragraph>
			</DefaultValue>
		</FieldHelp>
		<FieldHelp ID="errt.yeno"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">File to Store Table Names not Created</Title>
			</Header>
			<FuncDesc>
                                 If this check box is selected, the names of tables that cannot be created are stored in a file. You must enter the file name in the next field.</FuncDesc>
		</FieldHelp>
		<FieldHelp ID="errt"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">File to Store Table Names not Created</Title>
			</Header>
			<FuncDesc>The file in which the names of tables that cannot be created are stored.</FuncDesc>
		</FieldHelp>
		<FieldHelp ID="flnm"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Name of the Dump File</Title>
			</Header>
			<FuncDesc>The name, including the path, of the file in which the sequential dump of the tables is stored. For example: /tmp/dump.400.</FuncDesc>
		</FieldHelp>
		<FieldHelp ID="errf"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Name of the Error File</Title>
			</Header>
			<FuncDesc>Specifies the name, including the path, of the file to which all error messages and statistics information is written.</FuncDesc>
		</FieldHelp>
	</Fields>
</Session>
