/text/shared/explorer/database/dabapropadd.xhp

Additional Settings Specifies additional options for a data source.

In a database window, choose Edit - Database - Properties, click Additional Settings tab

The availability of the following controls depends on the type of database: Host name Enter the host name of the server that contains the database, for example ldap.server.com.used for multiple database formats Port number Enter the port number for the server that hosts the database.UFI: used for LDAP and MySQL, different default values MySQL JDBC driver class Enter the name of the JDBC driver for the MySQL database.UFI: copied from shared\explorer\database\11110000.xhp but that was changed before (??) Character setUFI: seen for dBaseand for text file folder Select the character set that you want to use to view the database in $[officename]. This setting does not affect the database. To use the default character set of your operating system, select "System". 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.UFI. copied from shared\explorer\database\11020000.xhp Oracle JDBC driver class Enter the name of the JDBC driver for the Oracle database.UFI: copied from shared\explorer\database\11110000.xhp but that was changed before (??) Driver settings Specify additional driver options.UFI. copied from shared\explorer\database\11020000.xhp Use catalog for file-based databases 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.UFI. copied from shared\explorer\database\11020000.xhp Base DN Enter the starting point to search the LDAP database, for example, dc=com.copied from shared\explorer\database\11190000.xhp Maximum number of records Enter the maximum number of records that you want to load when you access the LDAP server. Display deleted records as wellUFI: seen for dBase, but Help ID is somewhere else Displays all the records in a file, including those marked as deleted. If you select this check box, you cannot delete records.copied from shared\explorer\database\11030000.xhp In dBASE format, deleted records remain in the file. To view changes that you make to the database, close the connection to the database, and then reconnect to the database. IndexesUFI: seen for dBase Opens the Indexes dialog, where you can organize the table indexes in the current dBASE database.UFI: removed link from extended help text UFI: Commercial means AdabasData buffer size (MB) Enter the size of the data buffer for the database. The setting takes effect after you restart the database.copied from shared\explorer\database\11170000.xhp Data increment (MB) 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. Control user name Enter the name of a user that you want to give limited control to modify some parameters of the database. Control password Enter the password for the Control User. Shut down service when closing %PRODUCTNAME 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. Extended Opens the Database Statistics dialog, where you can view statistics about the Adabas database. Text contains headersUFI: the following found for a text file folder, but HELP Ids are somewhere else Select this check box if the first line of the text file contains field names.copied from shared\explorer\database\11040000.xhp Field separator Enter or select the character that separates data fields in the text file. Text separator Enter or select the character that identifies a text field in the text file. You cannot use the same character as the field separator. Decimal separator 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). Thousands separator 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). File extension Select the format for the text file. The extension that you select affects some of the default settings in this dialog.