1<?xml version="1.0" encoding="UTF-8"?> 2 3 4 5<!--*********************************************************** 6 * 7 * Licensed to the Apache Software Foundation (ASF) under one 8 * or more contributor license agreements. See the NOTICE file 9 * distributed with this work for additional information 10 * regarding copyright ownership. The ASF licenses this file 11 * to you under the Apache License, Version 2.0 (the 12 * "License"); you may not use this file except in compliance 13 * with the License. You may obtain a copy of the License at 14 * 15 * http://www.apache.org/licenses/LICENSE-2.0 16 * 17 * Unless required by applicable law or agreed to in writing, 18 * software distributed under the License is distributed on an 19 * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY 20 * KIND, either express or implied. See the License for the 21 * specific language governing permissions and limitations 22 * under the License. 23 * 24 ***********************************************************--> 25 26 27 28 29 <helpdocument version="1.0"> 30<meta> 31<topic id="textsharedexplorerdatabasedabapropaddxml" indexer="include" status="PUBLISH"> 32<title id="tit" xml-lang="en-US">Additional Settings</title> 33<filename>/text/shared/explorer/database/dabapropadd.xhp</filename> 34</topic> 35</meta> 36<body> 37<section id="dabapropadd"> 38<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> 39<paragraph role="paragraph" id="par_idN1055D" xml-lang="en-US" l10n="NEW"><ahelp hid=".">Specifies additional options for a data source.</ahelp></paragraph> 40</section> 41<section id="howtoget"> 42<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> 43</section> 44<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> 45<paragraph role="heading" id="par_idN10575" xml-lang="en-US" level="2" l10n="NEW">Host name</paragraph> 46<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> 47<paragraph role="heading" id="par_idN10579" xml-lang="en-US" level="2" l10n="NEW">Port number</paragraph> 48<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> 49<paragraph role="heading" id="par_idN1057D" xml-lang="en-US" level="2" l10n="NEW">MySQL JDBC driver class</paragraph> 50<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> 51<bookmark xml-lang="en-US" branch="hid/DBACCESS_HID_DSADMIN_CHARSET" id="bm_id9317606" localize="false"/><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> 52<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> 53<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> 54<paragraph role="heading" id="par_idN10585" xml-lang="en-US" level="2" l10n="NEW">Oracle JDBC driver class</paragraph> 55<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> 56<paragraph role="heading" id="par_idN10589" xml-lang="en-US" level="2" l10n="NEW">Driver settings</paragraph> 57<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> 58<paragraph role="heading" id="par_idN1058D" xml-lang="en-US" level="2" l10n="NEW">Use catalog for file-based databases</paragraph> 59<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> 60<paragraph role="heading" id="par_idN10591" xml-lang="en-US" level="2" l10n="NEW">Base DN</paragraph> 61<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> 62<paragraph role="heading" id="par_idN10595" xml-lang="en-US" level="2" l10n="NEW">Maximum number of records</paragraph> 63<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> 64<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> 65<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> 66<paragraph role="note" id="par_idN10715" xml-lang="en-US" l10n="NEW">In dBASE format, deleted records remain in the file.</paragraph> 67<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> 68<paragraph role="heading" id="par_idN1059D" xml-lang="en-US" level="2" l10n="NEW">Indexes<comment>UFI: seen for dBase</comment></paragraph> 69<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> 70<paragraph role="heading" id="par_idN105A1" xml-lang="en-US" level="2" l10n="NEW">Data buffer size (MB)</paragraph> 71<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> 72<paragraph role="heading" id="par_idN105A5" xml-lang="en-US" level="2" l10n="NEW">Data increment (MB)</paragraph> 73<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> 74<paragraph role="heading" id="par_idN105A9" xml-lang="en-US" level="2" l10n="NEW">Control user name</paragraph> 75<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> 76<paragraph role="heading" id="par_idN105AD" xml-lang="en-US" level="2" l10n="NEW">Control password</paragraph> 77<paragraph role="paragraph" id="par_idN1077B" xml-lang="en-US" l10n="NEW"><ahelp hid=".">Enter the password for the Control User.</ahelp></paragraph> 78<paragraph role="heading" id="par_idN105B1" xml-lang="en-US" level="2" l10n="NEW">Shut down service when closing %PRODUCTNAME</paragraph> 79<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> 80<paragraph role="heading" id="par_idN105B5" xml-lang="en-US" level="2" l10n="NEW">Extended</paragraph> 81<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> 82<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> 83<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> 84<paragraph role="heading" id="par_idN105BD" xml-lang="en-US" level="2" l10n="NEW">Field separator</paragraph> 85<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> 86<paragraph role="heading" id="par_idN105C1" xml-lang="en-US" level="2" l10n="NEW">Text separator</paragraph> 87<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> 88<paragraph role="heading" id="par_idN105C5" xml-lang="en-US" level="2" l10n="NEW">Decimal separator</paragraph> 89<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> 90<paragraph role="heading" id="par_idN105C9" xml-lang="en-US" level="2" l10n="NEW">Thousands separator</paragraph> 91<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> 92<paragraph role="heading" id="par_idN105CD" xml-lang="en-US" level="2" l10n="NEW">File extension</paragraph> 93<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> 94</body> 95</helpdocument> 96