dbsrv16 @data ...

All operating systems and database servers, except Windows Mobile. It is supported for all database utilities except the Language Selection utility (dblang), the Certificate Creation utility (createcert), the Certificate Viewer utility (viewcert), the Microsoft ActiveSync provider install utility (mlasinst), and the File Hiding utility (dbfhide).

• the Language Selection utility (dblang)
• the Certificate Creation utility (createcert)
• the Certificate Viewer utility (viewcert)
• the Microsoft ActiveSync provider install utility (mlasinst)
• the File Hiding utility (dbfhide)

Use this option to read in command-line options from the specified environment variable or configuration file. If both exist with the same name that is specified, the environment variable is used.

Configuration files can contain line breaks, and can contain any set of options.

To protect the information in a configuration file (for example, because it contains passwords), use the File Hiding (dbfhide) utility to obfuscate the contents of configuration files.

The @data parameter can occur at any point in the command, and parameters contained in the file are inserted at that point. Multiple files can be specified, and the file specifier can be used with command line options.

• Configuration files
• File Hiding utility (dbfhide)

The following configuration file holds a set of options for a server named myserver that starts with a cache size of 4 MB and loads the sample database:

-c 4096
-n myserver
"c:\mydatabase.db"

If this configuration file is saved as c:\config.txt, it can be used in a command as follows:

dbsrv16 @c:\config.txt

The following configuration file contains comments:

#This is the server name:
-n MyServer
#These are the protocols:
-x tcpip
#This is the database file
my.db

The following statement sets an environment variable that holds options for a database server that starts with a cache size of 4 MB and loads the sample database.

SET envvar=-c 4096 "c:\mydatabase.db";

The following command starts the database server using an environment variable named envvar.

dbsrv16 @envvar