<?xml version="1.0" encoding="utf-8"?>
<Session ID="/baanerp/tt/aad/ttaad4100" xml:lang="en">
	<Header>
		<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">General Table Maintenance (ttaad4100 )</Title>
	</Header>
	<HelpTopic xml:lang="en"><AimSection><Paragraph class="Default"> 
                                 Use this session to manipulate table field data without using sessions (which is the usual way). This particular session is meant only for developers.</Paragraph>
		</AimSection>
		<GeneralSection><Paragraph class="Default">Inappropriate usage is can result in data inconsistency!</Paragraph>
			<Paragraph class="Default">Enter the codes of the package, module, table and company for which you want to maintain the table data. Press [Y] in the choice field to access the table fields.</Paragraph>
			<Paragraph class="Default">If you press the spacebar, a pull-down menu with standard options appears at the top of your screen. The options are grouped in 7 menus. The use of these options may deviate from the standard use. For example, after you have selected "Global Delete" you can specify the range with a selection screen (From-To). You do not have to mark records.</Paragraph>
			<Paragraph class="Default">It is possible to call help information by table field. Press [?] to get table field help.</Paragraph>
		</GeneralSection>
		<Note><SectionTitle>
                                 Note
                              </SectionTitle>
			<Paragraph class="Default">You can use the <GUIRef href="" role="command">Change Data Language</GUIRef> command in the <GUIRef href="" role="command">CONTROL</GUIRef> pull-down menu to display the table data in a different <Link href="/baanerp/tt/glossary/glossary#100111" role="glossary">Data Language</Link>. This is only possible if fields of the table are registered as multilanguage fields. For more information, refer to <Link href="/baanerp/tt/onlinemanual/mle_multi_language_application_data" role="manual">Multilanguage Application Data</Link>.</Paragraph>
		</Note>
		<GeneralSection><SectionTitle>APPLICATION pull-down menu</SectionTitle>
			<Paragraph class="Default">The last group of options is "APPLICATION". This group contains options which are only used for table maintenance. There are 11 items.</Paragraph>
			<GeneralSection><SectionTitle>0 Table Information</SectionTitle>
				<Paragraph class="Default">A window appears with general table information.</Paragraph>
				<List><ListIntro>This information consists of:</ListIntro>
					<ListItem>table code</ListItem>
					<ListItem>row/record length</ListItem>
					<ListItem>number of rows/records</ListItem>
					<ListItem>number of indices</ListItem>
				</List>
				<List><ListIntro>If indices &gt; 1 you can change the index with option [K]</ListIntro>
					<ListItem>current index</ListItem>
					<ListItem>duplicates (y/n)</ListItem>
				</List>
			</GeneralSection>
			<GeneralSection><SectionTitle>1 Copy Rows</SectionTitle>
				<Paragraph class="Default">You can copy records from another table. By using certain parameters in a file it is possible to copy parts of fields from another table to parts of fields of the current table.</Paragraph>
				<Paragraph class="Default">Each line of the parameter file has the following syntax:</Paragraph>
				<Paragraph class="Default">x y z [expression]</Paragraph>
				<Paragraph class="Default">or</Paragraph>
				<Paragraph class="Default">c x y expression</Paragraph>
				<Paragraph class="Default">The first line means:</Paragraph>
				<Paragraph class="Default">copy position x and length y to position z in the current table.</Paragraph>
				<Paragraph class="Default">It is also possible to enter an expression behind: x y z ^abc</Paragraph>
				<Paragraph class="Default">This means: copy position x and length y to position z, only if the string `abc' is in the positions x, x+1 and x+2.</Paragraph>
				<Paragraph class="Default">The second line means:</Paragraph>
				<Paragraph class="Default">Only if the expression is true for position x and length y, carry out any action. Skip the record if expression is false.</Paragraph>
				<List><ListIntro>Notes:</ListIntro>
					<ListItem>On the first line the expression is not needed, in the second it is.</ListItem>
					<ListItem>x,y and z are values, the character c is the normal character "c".</ListItem>
					<ListItem>Expressions are only working for string fields.</ListItem>
					<ListItem>Maximum number of lines in parameter file : 50</ListItem>
				</List>
			</GeneralSection>
			<GeneralSection><SectionTitle>2 Export Data</SectionTitle>
				<Paragraph class="Default">You can export the current table to a sequential file (compressed dump). Specify a directory into which the dump must be stored. With Import Data you can import the table into another system.</Paragraph>
			</GeneralSection>
			<GeneralSection><SectionTitle>3 Import Data</SectionTitle>
				<Paragraph class="Default">You can import a table of another system (environment). Specify the directory in which the dump has been stored.</Paragraph>
			</GeneralSection>
			<GeneralSection><SectionTitle>4 Count Rows</SectionTitle>
				<Paragraph class="Default">This utility will give you the number of records of the table. You can specify the range of index fields in which you can select the records which will be counted.</Paragraph>
			</GeneralSection>
			<GeneralSection><SectionTitle>5 Modify Rows</SectionTitle>
				<Paragraph class="Default">With this option you can modify a range of records in the current table.</Paragraph>
			</GeneralSection>
			<GeneralSection><SectionTitle>6 Remove Rows</SectionTitle>
				<Paragraph class="Default">Remove Rows With this option you can remove a range of records from the current table.</Paragraph>
			</GeneralSection>
			<GeneralSection><SectionTitle>* Toggle User Mode/Programmers Mode</SectionTitle>
				<Paragraph class="Default">Programmers mode gives you detailed information (information for the programmer) about the table.</Paragraph>
			</GeneralSection>
		</GeneralSection>
		<RelatedTopics><SectionTitle>
                                 Related topics
                              </SectionTitle>
			<RelTopic><Link href="/baanerp/basictasks/000001" role="manual">To use an overview session</Link>
			</RelTopic>
			<RelTopic><Link href="/baanerp/basictasks/000035" role="manual">To maintain records in an overview session</Link>
			</RelTopic>
		</RelatedTopics>
	</HelpTopic>
</Session>
