1cdf0e10cSrcweir<?xml version="1.0" encoding="UTF-8"?> 2cdf0e10cSrcweir 30ba1032bSAndrew Rist<!--*********************************************************** 495f9d078Smseidel * 50ba1032bSAndrew Rist * Licensed to the Apache Software Foundation (ASF) under one 60ba1032bSAndrew Rist * or more contributor license agreements. See the NOTICE file 70ba1032bSAndrew Rist * distributed with this work for additional information 80ba1032bSAndrew Rist * regarding copyright ownership. The ASF licenses this file 90ba1032bSAndrew Rist * to you under the Apache License, Version 2.0 (the 100ba1032bSAndrew Rist * "License"); you may not use this file except in compliance 110ba1032bSAndrew Rist * with the License. You may obtain a copy of the License at 1295f9d078Smseidel * 130ba1032bSAndrew Rist * http://www.apache.org/licenses/LICENSE-2.0 1495f9d078Smseidel * 150ba1032bSAndrew Rist * Unless required by applicable law or agreed to in writing, 160ba1032bSAndrew Rist * software distributed under the License is distributed on an 170ba1032bSAndrew Rist * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY 180ba1032bSAndrew Rist * KIND, either express or implied. See the License for the 190ba1032bSAndrew Rist * specific language governing permissions and limitations 200ba1032bSAndrew Rist * under the License. 2195f9d078Smseidel * 220ba1032bSAndrew Rist ***********************************************************--> 230ba1032bSAndrew Rist 2495f9d078Smseidel<helpdocument version="1.0"> 25cdf0e10cSrcweir<meta> 26cdf0e10cSrcweir<topic id="textsharedexplorerdatabasedabapropaddxml" indexer="include" status="PUBLISH"> 27cdf0e10cSrcweir<title id="tit" xml-lang="en-US">Additional Settings</title> 28cdf0e10cSrcweir<filename>/text/shared/explorer/database/dabapropadd.xhp</filename> 29cdf0e10cSrcweir</topic> 30cdf0e10cSrcweir</meta> 31cdf0e10cSrcweir<body> 32cdf0e10cSrcweir<section id="dabapropadd"> 33cdf0e10cSrcweir<paragraph role="heading" id="par_idN1054D" xml-lang="en-US" level="1" l10n="NEW"><link href="text/shared/explorer/database/dabapropadd.xhp">Additional Settings</link></paragraph> 34cdf0e10cSrcweir<paragraph role="paragraph" id="par_idN1055D" xml-lang="en-US" l10n="NEW"><ahelp hid=".">Specifies additional options for a data source.</ahelp></paragraph> 35cdf0e10cSrcweir</section> 36cdf0e10cSrcweir<section id="howtoget"> 37cdf0e10cSrcweir<paragraph role="paragraph" id="par_id4641865" xml-lang="en-US" l10n="NEW">In a database window, choose <emph>Edit - Database - Properties</emph>, click <emph>Additional Settings</emph> tab</paragraph> 38cdf0e10cSrcweir</section> 39cdf0e10cSrcweir<paragraph role="paragraph" id="par_idN10572" xml-lang="en-US" l10n="CHG">The availability of the following controls depends on the type of database:</paragraph> 40cdf0e10cSrcweir<paragraph role="heading" id="par_idN10575" xml-lang="en-US" level="2" l10n="NEW">Host name</paragraph> 41cdf0e10cSrcweir<paragraph role="paragraph" id="par_idN105D7" xml-lang="en-US" l10n="NEW"><ahelp hid=".">Enter the host name of the server that contains the database, for example ldap.server.com.</ahelp><comment>used for multiple database formats</comment></paragraph> 42cdf0e10cSrcweir<paragraph role="heading" id="par_idN10579" xml-lang="en-US" level="2" l10n="NEW">Port number</paragraph> 43cdf0e10cSrcweir<paragraph role="paragraph" id="par_idN105F6" xml-lang="en-US" l10n="NEW"><ahelp hid=".">Enter the port number for the server that hosts the database.</ahelp><comment>UFI: used for LDAP and MySQL, different default values</comment></paragraph> 44cdf0e10cSrcweir<paragraph role="heading" id="par_idN1057D" xml-lang="en-US" level="2" l10n="NEW">MySQL JDBC driver class</paragraph> 45cdf0e10cSrcweir<paragraph role="paragraph" id="par_idN10615" xml-lang="en-US" l10n="NEW"><ahelp hid=".">Enter the name of the JDBC driver for the MySQL database.</ahelp><comment>UFI: copied from shared\explorer\database\11110000.xhp but that was changed before (??)</comment></paragraph> 46*77878c64Smseidel<bookmark xml-lang="en-US" branch="hid/DBACCESS_HID_DSADMIN_CHARSET" id="bm_id9317606" localize="false"/> 47*77878c64Smseidel<paragraph role="heading" id="par_idN10581" xml-lang="en-US" level="2" l10n="NEW">Character set<comment>UFI: seen for dBase</comment><comment>and for text file folder</comment></paragraph> 48cdf0e10cSrcweir<paragraph role="paragraph" id="par_idN10634" xml-lang="en-US" l10n="NEW"><ahelp hid=".">Select the character set that you want to use to view the database in $[officename].</ahelp> This setting does not affect the database. To use the default character set of your operating system, select "System".</paragraph> 49cdf0e10cSrcweir<paragraph role="note" id="par_idN10651" xml-lang="en-US" l10n="NEW">Text and dBASE databases are restricted to character sets with a fixed-size character length, where all characters are encoded with the same number of bytes.<comment>UFI. copied from shared\explorer\database\11020000.xhp</comment></paragraph> 50cdf0e10cSrcweir<paragraph role="heading" id="par_idN10585" xml-lang="en-US" level="2" l10n="NEW">Oracle JDBC driver class</paragraph> 51cdf0e10cSrcweir<paragraph role="paragraph" id="par_idN10653" xml-lang="en-US" l10n="NEW"><ahelp hid=".">Enter the name of the JDBC driver for the Oracle database.</ahelp><comment>UFI: copied from shared\explorer\database\11110000.xhp but that was changed before (??)</comment></paragraph> 52cdf0e10cSrcweir<paragraph role="heading" id="par_idN10589" xml-lang="en-US" level="2" l10n="NEW">Driver settings</paragraph> 53cdf0e10cSrcweir<paragraph role="paragraph" id="par_idN10672" xml-lang="en-US" l10n="NEW"><ahelp hid=".">Specify additional driver options.</ahelp><comment>UFI. copied from shared\explorer\database\11020000.xhp</comment></paragraph> 54cdf0e10cSrcweir<paragraph role="heading" id="par_idN1058D" xml-lang="en-US" level="2" l10n="NEW">Use catalog for file-based databases</paragraph> 55cdf0e10cSrcweir<paragraph role="paragraph" id="par_idN10691" xml-lang="en-US" l10n="NEW"><ahelp hid=".">Uses the current data source of the catalog. This option is useful when the ODBC data source is a database server. Do not select this option if the ODBC data source is a dBASE driver.</ahelp><comment>UFI. copied from shared\explorer\database\11020000.xhp</comment></paragraph> 56cdf0e10cSrcweir<paragraph role="heading" id="par_idN10591" xml-lang="en-US" level="2" l10n="NEW">Base DN</paragraph> 57cdf0e10cSrcweir<paragraph role="paragraph" id="par_idN106B0" xml-lang="en-US" l10n="NEW"><ahelp hid=".">Enter the starting point to search the LDAP database, for example, dc=com.</ahelp><comment>copied from shared\explorer\database\11190000.xhp</comment></paragraph> 58cdf0e10cSrcweir<paragraph role="heading" id="par_idN10595" xml-lang="en-US" level="2" l10n="NEW">Maximum number of records</paragraph> 59cdf0e10cSrcweir<paragraph role="paragraph" id="par_idN106F3" xml-lang="en-US" l10n="NEW"><ahelp hid=".">Enter the maximum number of records that you want to load when you access the LDAP server.</ahelp></paragraph> 60cdf0e10cSrcweir<paragraph role="heading" id="par_idN10599" xml-lang="en-US" level="2" l10n="NEW">Display deleted records as well<comment>UFI: seen for dBase, but Help ID is somewhere else</comment></paragraph> 61cdf0e10cSrcweir<paragraph role="paragraph" id="par_idN10700" xml-lang="en-US" l10n="NEW"><ahelp hid=".">Displays all the records in a file, including those marked as deleted. If you select this check box, you cannot delete records.</ahelp><comment>copied from shared\explorer\database\11030000.xhp</comment></paragraph> 62cdf0e10cSrcweir<paragraph role="note" id="par_idN10715" xml-lang="en-US" l10n="NEW">In dBASE format, deleted records remain in the file.</paragraph> 63cdf0e10cSrcweir<paragraph role="tip" id="par_idN10718" xml-lang="en-US" l10n="NEW">To view changes that you make to the database, close the connection to the database, and then reconnect to the database.</paragraph> 64cdf0e10cSrcweir<paragraph role="heading" id="par_idN1059D" xml-lang="en-US" level="2" l10n="NEW">Indexes<comment>UFI: seen for dBase</comment></paragraph> 65cdf0e10cSrcweir<paragraph role="paragraph" id="par_idN10725" xml-lang="en-US" l10n="CHG"><ahelp hid=".">Opens the Indexes dialog, where you can organize the table indexes in the current dBASE database.</ahelp><comment>UFI: removed link from extended help text</comment></paragraph> 66cdf0e10cSrcweir<paragraph role="heading" id="par_idN105A1" xml-lang="en-US" level="2" l10n="NEW">Data buffer size (MB)</paragraph> 67cdf0e10cSrcweir<paragraph role="paragraph" id="par_idN10742" xml-lang="en-US" l10n="NEW"><ahelp hid=".">Enter the size of the data buffer for the database. The setting takes effect after you restart the database.</ahelp><comment>copied from shared\explorer\database\11170000.xhp</comment></paragraph> 68cdf0e10cSrcweir<paragraph role="heading" id="par_idN105A5" xml-lang="en-US" level="2" l10n="NEW">Data increment (MB)</paragraph> 69cdf0e10cSrcweir<paragraph role="paragraph" id="par_idN10761" xml-lang="en-US" l10n="NEW"><ahelp hid=".">Enter the size by which you want to automatically increment the database. The maximum increment size is 100 MB. The setting takes effect after you restart the database.</ahelp></paragraph> 70cdf0e10cSrcweir<paragraph role="heading" id="par_idN105A9" xml-lang="en-US" level="2" l10n="NEW">Control user name</paragraph> 71cdf0e10cSrcweir<paragraph role="paragraph" id="par_idN1076E" xml-lang="en-US" l10n="NEW"><ahelp hid=".">Enter the name of a user that you want to give limited control to modify some parameters of the database.</ahelp></paragraph> 72cdf0e10cSrcweir<paragraph role="heading" id="par_idN105AD" xml-lang="en-US" level="2" l10n="NEW">Control password</paragraph> 73cdf0e10cSrcweir<paragraph role="paragraph" id="par_idN1077B" xml-lang="en-US" l10n="NEW"><ahelp hid=".">Enter the password for the Control User.</ahelp></paragraph> 74cdf0e10cSrcweir<paragraph role="heading" id="par_idN105B1" xml-lang="en-US" level="2" l10n="NEW">Shut down service when closing %PRODUCTNAME</paragraph> 75cdf0e10cSrcweir<paragraph role="paragraph" id="par_idN10788" xml-lang="en-US" l10n="NEW"><ahelp hid=".">Exits the Adabas database server when you exit $[officename]. This option is only available if you start the database server from $[officename] with a control user and password.</ahelp></paragraph> 76cdf0e10cSrcweir<paragraph role="heading" id="par_idN105B5" xml-lang="en-US" level="2" l10n="NEW">Extended</paragraph> 77cdf0e10cSrcweir<paragraph role="paragraph" id="par_idN10795" xml-lang="en-US" l10n="NEW"><ahelp hid=".">Opens the <link href="text/shared/explorer/database/11170100.xhp" name="Database Statistics">Database Statistics</link> dialog, where you can view statistics about the Adabas database.</ahelp></paragraph> 78cdf0e10cSrcweir<paragraph role="heading" id="par_idN105B9" xml-lang="en-US" level="2" l10n="NEW">Text contains headers<comment>UFI: the following found for a text file folder, but HELP Ids are somewhere else</comment></paragraph> 79cdf0e10cSrcweir<paragraph role="paragraph" id="par_idN107B0" xml-lang="en-US" l10n="NEW"><ahelp hid=".">Select this check box if the first line of the text file contains field names.</ahelp><comment>copied from shared\explorer\database\11040000.xhp</comment></paragraph> 80cdf0e10cSrcweir<paragraph role="heading" id="par_idN105BD" xml-lang="en-US" level="2" l10n="NEW">Field separator</paragraph> 81cdf0e10cSrcweir<paragraph role="paragraph" id="par_idN107CF" xml-lang="en-US" l10n="NEW"><ahelp hid=".">Enter or select the character that separates data fields in the text file.</ahelp></paragraph> 82cdf0e10cSrcweir<paragraph role="heading" id="par_idN105C1" xml-lang="en-US" level="2" l10n="NEW">Text separator</paragraph> 83cdf0e10cSrcweir<paragraph role="paragraph" id="par_idN107DC" xml-lang="en-US" l10n="NEW"><ahelp hid=".">Enter or select the character that identifies a text field in the text file. You cannot use the same character as the field separator.</ahelp></paragraph> 84cdf0e10cSrcweir<paragraph role="heading" id="par_idN105C5" xml-lang="en-US" level="2" l10n="NEW">Decimal separator</paragraph> 85cdf0e10cSrcweir<paragraph role="paragraph" id="par_idN107E9" xml-lang="en-US" l10n="NEW"><ahelp hid=".">Enter or select the character that is used as a decimal separator in the text file, for example, a period (0.5) or a comma (0,5).</ahelp></paragraph> 86cdf0e10cSrcweir<paragraph role="heading" id="par_idN105C9" xml-lang="en-US" level="2" l10n="NEW">Thousands separator</paragraph> 87cdf0e10cSrcweir<paragraph role="paragraph" id="par_idN107F6" xml-lang="en-US" l10n="NEW"><ahelp hid=".">Enter or select the character that is used as a thousands separator in the text file, for example a comma (1,000), or a period (1.000).</ahelp></paragraph> 88cdf0e10cSrcweir<paragraph role="heading" id="par_idN105CD" xml-lang="en-US" level="2" l10n="NEW">File extension</paragraph> 89ffd78038Smseidel<paragraph role="paragraph" id="par_idN10803" xml-lang="en-US" l10n="NEW"><ahelp hid=".">Select the format for the text file.</ahelp> The extension that you select affects some of the default settings in this dialog.</paragraph> 90cdf0e10cSrcweir</body> 91cdf0e10cSrcweir</helpdocument> 92