Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 11.0.1 » SQL Anywhere Server - Database Administration » Starting and Connecting to Your Database » The database server » Database server options

 

@data server option

Reads in options from the specified environment variable or configuration file.

Syntax
{ dbsrv11 | dbeng11 } @data ...
Applies to

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

Remarks

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. See Using configuration files.

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

The @data parameter can occur at any point in the command line, 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.

See also
Example

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:

dbsrv11 @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";

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

dbsrv11 @envvar