Preferences

The Preferences section contains the following tabs:

Data File Editor

You can set the following preferences when using the Data File Editor:

Records per page

Set the amount of records you want to display per page. The more records you display per page, the more memory that is required; therefore, reduce the amount of records per page if you receive memory problems. Use the and icons to navigate the pages of records.

Note: You must restart Data File Editor before any changes to this setting take effect.

Maximum number of requested data sets

Set the number of data sets requested when expanding an enterprise server region catalog in Data Explorer. When a catalog contains more data sets than requested, a More data sets in catalog stub will appear at the end of the data set list. It is recommended that you keep the number of requested data sets small and use filters to access specific data sets in large catalogs.

Default value: 100.

Maximum value: 5000.

Quick final page access

For large variable sequential files (files > 10,000 records), select this option to immediately jump to the last page of the file when it is opened. When this option is in effect, the last n records are displayed, as per the Records per page setting; from this point, you can navigate the file as normal.

Padding Character

Each new record is immediately padded with the characters you specify here for both ANSI and EBCDIC encoding. Enter the character in the top cell of the box next to the encoding name.

Copy and Paste to External Destination

This option sets a character to replace a NULL byte when copying a record to an external destination. By default, this character is set to a period. Use the Replace NULL character field to set the replacement character.

Temporary Directory

Set the location of a temporary directory that is required in order to filter a data file. You can specify either an absolute or a relative (to the current working directory) path. An invalid path, or no path at all, will produce an error when you attempt to apply a filter.

Dialog boxes when using a temporary file

When using a temporary file whilst making edits, the default behavior is to not display the confirmation dialog boxes each time you update a record (as the record is only written to the temporary file, not data file, at this point). You can turn these confirmation messages back on whilst using a temporary file by clearing the option Do not show update warning when editing using temporary file.

Search

Max Record

When using filtering or find/replace on files in Fileshare, use this option to pause the operation every x records. This limits the performance impact on Fileshare, as the pause allows Fileshare to process other requests. The default value 0 will not set a limit.

Security

If you are connecting to an enterprise server using an SSL connection, use the Certificate Authority Trust Store setting to specify the trust store that contains the trusted root certificate used by the connection.

To use this setting requires that you have already created a trust store that includes a CA root certificate or (for non-production scenarios only) a self-signed certificate on your client, and that the enterprise server that you are connecting to has a valid server certificate (which is used to establish the server/client connection) and private key (for encryption) configured.

The required trust store is Java-specific, and so we recommend that to create the trust store, you use the keytool utility from the JDK that matches your version of Java. Type the following into a Enterprise Developer command prompt to create a trust store:

keytool -importcert -alias alias -keyalg alg -file CARootECcert.pem -keystore keystore.jks

where alias is the name of the certificate, alg is the name of the security algorithm to generate the key pair, and keystore.jks is the name of the trust store to be generated. Refer to the keytool utility documentation on the Oracle web site (http://docs.oracle.com/en/java/) for more information.

If your trust store is password protected, you must specify the password via the Java property javax.net.ssl.trustStorePassword:

-Djavax.net.ssl.trustStorePassword=myKeyStorePassword

To configure an enterprise server to use an SSL connection, create a listener that specifies the server certificate and keyfile. This type of listener does not automatically start when you start the enterprise server; it must be authorized after the server has started, by entering the key's passphrase, before the listener starts.