<?xml version="1.0" encoding="utf-8"?>
<Session ID="/baanerp/tt/aad/ttaad4226m000" xml:lang="en">
	<Header>
		<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Create Sequential Dump of Table (ttaad4226m000)</Title>
	</Header>
	<HelpTopic xml:lang="en"><AimSection><Paragraph class="Default">
                                 Use this session to export data from ERP LN database tables to one or more sequential files. This session reads tables for the selected company numbers, converts them into sequential data and writes out the results into specified files on the Operating System.</Paragraph>
		</AimSection>
		<GeneralSection><SectionTitle>Session usage</SectionTitle>
			<List><ListIntro>To extract data:</ListIntro>
				<ListItem>Select the range of company number(s) and tables from which you want to extract data</ListItem>
				<ListItem>Use the remaining fields and check boxes to specify the settings for the extraction process. Refer to the online field help for details.</ListItem>
				<ListItem>Click <GUIRef href="" role="manual">Create</GUIRef>.</ListItem>
			</List>
		</GeneralSection>
		<GeneralSection><SectionTitle>Sequential file types</SectionTitle>
			<List><ListIntro>During the extraction, the data is converted to one of the following:</ListIntro>
				<ListItem>sequential files with a field separator. A separate sequential file is generated for each table in the selection range. Use this option if you want to copy data to another company number. You can also easily load the content of the sequential files into any database using SQL, or into applications such as MS Excel. To use this option, select the <GUIRef href="/baanerp/tt/aad/ttaad4226m000#fsep.yeno" role="manual">Specify Field Separators</GUIRef> check box and specify the separator in the <GUIRef href="/baanerp/tt/aad/ttaad4226m000#sepa" role="manual">Specify Field Separators</GUIRef> field.</ListItem>
				<ListItem>sequential files with a fixed record length. A separate sequential file is generated for each table in the selection range. This option is useful for downloading data to databases such as dBASE, which require fixed length records without separators. To use this option, select the <GUIRef href="/baanerp/tt/aad/ttaad4226m000#fixl.yeno" role="manual">Create Fixed Length Records</GUIRef> check box.</ListItem>
				<ListItem>one or more sequential dump files, containing the records and the data dictionary information of all tables in the selection range. A separate dump file is generated for each selected company. To use this option, enter the basic name of the dump file in the <GUIRef href="/baanerp/tt/aad/ttaad4226m000#flnm" role="manual">Basic Name for Dump File(s)</GUIRef> field. The session automatically adds a company number extension to the basic file name.</ListItem>
			</List>
		</GeneralSection>
		<GeneralSection ID="copy_to_other_company"><SectionTitle>Copy data to another company</SectionTitle>
			<Paragraph class="Default">If you want to copy the extracted data to another company, you must always use sequential files with a field separator: 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">To load the content of the sequential files into another company, use the <GUIRef href="/baanerp/tt/aad/ttaad4227m000" role="session">Create Table from Sequential Dump (ttaad4227m000)</GUIRef> session.</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 bdbpre6.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="serr.yeno"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Suppress Error Messages</Title>
			</Header>
			<FuncDesc> 
                                 If this check box is selected, no messages or information will be displayed. Error messages can be found in the log.bdbpre6.2 log file.</FuncDesc>
		</FieldHelp>
		<FieldHelp ID="drtb.yeno"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Drop Table after Dump</Title>
			</Header>
			<FuncDesc> 
                                 If this check box is selected, the physical tables are deleted after the dump is created.</FuncDesc>
		</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, logical tables are skipped during the export. ERP LN exports only tables that are physically stored in the selected companies. Shared tables are exported only once, when you export a logical company together with its physical company. 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, both, physical and logical tables, are exported. Shared tables are exported twice, when you export a logical company together with its physical company.</Paragraph>
			</SimpleSection>
		</FieldHelp>
		<FieldHelp ID="dlans"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Language(s)</Title>
			</Header>
			<FuncDesc>The <Link href="/baanerp/tt/glossary/glossary#100111" role="glossary" Update="No">Data Language(s)</Link> for which you want to export data.</FuncDesc>
			<SimpleSection><Paragraph class="Default">The languages must be separated by commas, for example: nl,en_US,de</Paragraph>
				<Paragraph class="Default">You can zoom to the <GUIRef href="/baanerp/tt/aad/ttaad1111m000" role="session">Data Languages (ttaad1111m000)</GUIRef> session, and select multiple languages in one go.</Paragraph>
			</SimpleSection>
		</FieldHelp>
		<FieldHelp ID="fixl.yeno"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Create Fixed Length Records</Title>
			</Header>
			<FuncDesc> 
                                 If this check box is selected, an ASCII dump with a fixed record length and without any separators is created. A file with a .F extension is created for each of the specified tables. For example: the sequential file ttccom001550.F contains the data that is extracted from the tccom001 (Employees - General) table in company 550.</FuncDesc>
			<SimpleSection><Paragraph class="Default">This option is useful for downloading data to databases such as dBASE, which require fixed length records without separators.</Paragraph>
				<Paragraph class="Default">You must specify the directory where the sequential files will be generated in the <GUIRef href="/baanerp/tt/aad/ttaad4226m000#dirt" role="manual">Directory for Table Files</GUIRef> field.</Paragraph>
				<Paragraph class="Default"><GUIRef href="" role="manual">Important:</GUIRef> do not use this option if you want to copy the extracted data to another company number. Refer to <Link href="#copy_to_other_company" role="internal">Copy data to another company</Link> for details.</Paragraph>
			</SimpleSection>
		</FieldHelp>
		<FieldHelp ID="fsep.yeno"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Specify Field Separators</Title>
			</Header>
			<FuncDesc> 
                                 If this check box is selected, you can specify a field separator for the sequential files. A file with a .S extension is created for each of the specified tables. For example: the sequential file ttccom001550.S contains the data that is extracted from the tccom001 (Employees - General) table in company 550.</FuncDesc>
			<SimpleSection><Paragraph class="Default">You can easily load the content of the sequential files into ERP LN tables, into any database using SQL, or into applications such as MS Excel.</Paragraph>
				<Paragraph class="Default">You must specify the directory where the sequential files will be generated in the <GUIRef href="/baanerp/tt/aad/ttaad4226m000#dirt" role="manual">Directory for Table Files</GUIRef> field.</Paragraph>
				<Paragraph class="Default"><GUIRef href="" role="manual">Important:</GUIRef> you must use this option if you want to copy the extracted data to another company number.</Paragraph>
			</SimpleSection>
		</FieldHelp>
		<FieldHelp ID="sepa"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Specify Field Separators</Title>
			</Header>
			<FuncDesc>The field separator to be used in the sequential (.S extension) file. For example: a pipe (|), or a caret followed by a single uppercase alphabetical character: ^A, ^B, and so on.</FuncDesc>
			<DefaultValue><SectionTitle>
                                    Default value
                                 </SectionTitle>
				<Paragraph class="Default">\0</Paragraph>
			</DefaultValue>
		</FieldHelp>
		<FieldHelp ID="dirt"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Directory for Table Files</Title>
			</Header>
			<FuncDesc>The directory where the files with a fixed record length, or the files with a field separator, will be created.</FuncDesc>
		</FieldHelp>
		<FieldHelp ID="flnm"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Basic Name for Dump File(s)</Title>
			</Header>
			<FuncDesc>The basic name, including the path, of the sequential dump files. You can only generate sequential dump files if the <GUIRef href="/baanerp/tt/aad/ttaad4226m000#fixl.yeno" role="manual">Create Fixed Length Records</GUIRef> and <GUIRef href="/baanerp/tt/aad/ttaad4226m000#fsep.yeno" role="manual">Specify Field Separators</GUIRef> check boxes are cleared.</FuncDesc>
			<SimpleSection><Paragraph class="Default">The sequential dump files contain the records and the data dictionary information of all tables in the selection range. A separate dump file is generated for each selected company. The session automatically adds a company number extension to the basic file name.</Paragraph>
				<Paragraph class="Default"><GUIRef href="" role="manual">Example</GUIRef>
				</Paragraph>
				<List><ListIntro>You run this session with the following settings:</ListIntro>
					<ListItem>Company: 400-402</ListItem>
					<ListItem>Package: &lt;empty&gt; - zz</ListItem>
					<ListItem>Table: &lt;empty&gt; - zzz999</ListItem>
					<ListItem>Basic Name for Dump File(s): /tmp/dump</ListItem>
				</List>
				<Paragraph class="Default">3 dump files are generated: /tmp/dump.400, /tmp/dump.401 and /tmp/dump.402. Each dump file contains the records and the data dictionary information of all tables of the corresponding company.</Paragraph>
				<Paragraph class="Default"><GUIRef href="" role="manual">Important:</GUIRef> do not use this option if you want to copy the extracted data to another company number. Refer to <Link href="#copy_to_other_company" role="internal">Copy data to another company</Link> for details.</Paragraph>
			</SimpleSection>
		</FieldHelp>
		<FieldHelp ID="file.size"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Max. File Size</Title>
			</Header>
			<FuncDesc>Use this field to specify the maximum size for output files with a fixed record length, or for output files with a field separator. If the maximum file size is reached, ERP LN opens and fills a new file with a sequence number.</FuncDesc>
			<SimpleSection><Paragraph class="Default">To specify the size, enter a number in this field and a unit of storage, such as bytes, Kbytes, Mbytes, or Gbites, in the following field. The maximum size is 2 GB.</Paragraph>
				<List><ListIntro>You can only specify a maximum file size if one of the following check boxes is selected:</ListIntro>
					<ListItem><GUIRef href="/baanerp/tt/aad/ttaad4226m000#fixl.yeno" role="manual">Create Fixed Length Records</GUIRef>
					</ListItem>
					<ListItem><GUIRef href="/baanerp/tt/aad/ttaad4226m000#fsep.yeno" role="manual">Specify Field Separators</GUIRef>
					</ListItem>
				</List>
			</SimpleSection>
		</FieldHelp>
		<FieldHelp ID="size"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Max. File Size</Title>
			</Header>
			<FuncDesc>Use this field to specify the unit of storage for the maximum size for output files with a fixed record length, or for output files with a field separator.</FuncDesc>
			<SimpleSection><Paragraph class="Default">You can select bytes, Kbytes, Mbytes, or Gbites.</Paragraph>
			</SimpleSection>
		</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>
