1 <?xml version=
"1.0" encoding=
"UTF-8"?>
6 ***********************************************************************
8 * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER.
10 * Copyright 2008 by Sun Microsystems, Inc.
12 * OpenOffice.org - a multi-platform office productivity suite
14 * $RCSfile: dabapropadd.xhp,v $
17 * This file is part of OpenOffice.org.
19 * OpenOffice.org is free software: you can redistribute it and/or modify
20 * it under the terms of the GNU Lesser General Public License version 3
21 * only, as published by the Free Software Foundation.
23 * OpenOffice.org is distributed in the hope that it will be useful,
24 * but WITHOUT ANY WARRANTY; without even the implied warranty of
25 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
26 * GNU Lesser General Public License version 3 for more details
27 * (a copy is included in the LICENSE file that accompanied this code).
29 * You should have received a copy of the GNU Lesser General Public License
30 * version 3 along with OpenOffice.org. If not, see
31 * <http://www.openoffice.org/license.html>
32 * for a copy of the LGPLv3 License.
34 ************************************************************************
38 <helpdocument version=
"1.0">
40 <topic id=
"textsharedexplorerdatabasedabapropaddxml" indexer=
"include" status=
"PUBLISH">
41 <title id=
"tit" xml-lang=
"en-US">Additional Settings
</title>
42 <filename>/text/shared/explorer/database/dabapropadd.xhp
</filename>
46 <section id=
"dabapropadd">
47 <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>
48 <paragraph role=
"paragraph" id=
"par_idN1055D" xml-lang=
"en-US" l10n=
"NEW"><ahelp hid=
".">Specifies additional options for a data source.
</ahelp></paragraph>
50 <section id=
"howtoget">
51 <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>
53 <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>
54 <paragraph role=
"heading" id=
"par_idN10575" xml-lang=
"en-US" level=
"2" l10n=
"NEW">Host name
</paragraph>
55 <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>
56 <paragraph role=
"heading" id=
"par_idN10579" xml-lang=
"en-US" level=
"2" l10n=
"NEW">Port number
</paragraph>
57 <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>
58 <paragraph role=
"heading" id=
"par_idN1057D" xml-lang=
"en-US" level=
"2" l10n=
"NEW">MySQL JDBC driver class
</paragraph>
59 <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>
60 <bookmark xml-lang=
"en-US" branch=
"hid/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>
61 <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>
62 <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>
63 <paragraph role=
"heading" id=
"par_idN10585" xml-lang=
"en-US" level=
"2" l10n=
"NEW">Oracle JDBC driver class
</paragraph>
64 <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>
65 <paragraph role=
"heading" id=
"par_idN10589" xml-lang=
"en-US" level=
"2" l10n=
"NEW">Driver settings
</paragraph>
66 <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>
67 <paragraph role=
"heading" id=
"par_idN1058D" xml-lang=
"en-US" level=
"2" l10n=
"NEW">Use catalog for file-based databases
</paragraph>
68 <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>
69 <paragraph role=
"heading" id=
"par_idN10591" xml-lang=
"en-US" level=
"2" l10n=
"NEW">Base DN
</paragraph>
70 <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>
71 <paragraph role=
"heading" id=
"par_idN10595" xml-lang=
"en-US" level=
"2" l10n=
"NEW">Maximum number of records
</paragraph>
72 <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>
73 <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>
74 <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>
75 <paragraph role=
"note" id=
"par_idN10715" xml-lang=
"en-US" l10n=
"NEW">In dBASE format, deleted records remain in the file.
</paragraph>
76 <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>
77 <paragraph role=
"heading" id=
"par_idN1059D" xml-lang=
"en-US" level=
"2" l10n=
"NEW">Indexes
<comment>UFI: seen for dBase
</comment></paragraph>
78 <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>
79 <switch select=
"distrib">
80 <case select=
"COMMERCIAL"><comment>UFI: Commercial means Adabas
</comment><paragraph role=
"heading" id=
"par_idN105A1" xml-lang=
"en-US" level=
"2" l10n=
"NEW">Data buffer size (MB)
</paragraph>
81 <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>
82 <paragraph role=
"heading" id=
"par_idN105A5" xml-lang=
"en-US" level=
"2" l10n=
"NEW">Data increment (MB)
</paragraph>
83 <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>
84 <paragraph role=
"heading" id=
"par_idN105A9" xml-lang=
"en-US" level=
"2" l10n=
"NEW">Control user name
</paragraph>
85 <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>
86 <paragraph role=
"heading" id=
"par_idN105AD" xml-lang=
"en-US" level=
"2" l10n=
"NEW">Control password
</paragraph>
87 <paragraph role=
"paragraph" id=
"par_idN1077B" xml-lang=
"en-US" l10n=
"NEW"><ahelp hid=
".">Enter the password for the Control User.
</ahelp></paragraph>
88 <paragraph role=
"heading" id=
"par_idN105B1" xml-lang=
"en-US" level=
"2" l10n=
"NEW">Shut down service when closing %PRODUCTNAME
</paragraph>
89 <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>
90 <paragraph role=
"heading" id=
"par_idN105B5" xml-lang=
"en-US" level=
"2" l10n=
"NEW">Extended
</paragraph>
91 <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>
94 <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>
95 <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>
96 <paragraph role=
"heading" id=
"par_idN105BD" xml-lang=
"en-US" level=
"2" l10n=
"NEW">Field separator
</paragraph>
97 <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>
98 <paragraph role=
"heading" id=
"par_idN105C1" xml-lang=
"en-US" level=
"2" l10n=
"NEW">Text separator
</paragraph>
99 <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>
100 <paragraph role=
"heading" id=
"par_idN105C5" xml-lang=
"en-US" level=
"2" l10n=
"NEW">Decimal separator
</paragraph>
101 <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>
102 <paragraph role=
"heading" id=
"par_idN105C9" xml-lang=
"en-US" level=
"2" l10n=
"NEW">Thousands separator
</paragraph>
103 <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>
104 <paragraph role=
"heading" id=
"par_idN105CD" xml-lang=
"en-US" level=
"2" l10n=
"NEW">File extension
</paragraph>
105 <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>