ASA Database Administration Guide
The Database Server
The database server
Database server options
Read in server options from the supplied file. The number sign (#) must precede comments.
{ dbsrv9 | dbeng9 } @filename ...
All operating systems and servers, as well as all database utilities except Interactive SQL [dbisql], the Debugger utility [dbprdbg], the Language utility [dblang], and the Console utility [dbconsole].
The command file may contain line breaks, and may contain any set of options.
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.
For more information about the File Hiding utility, see The File Hiding utility.
All database utilities except Interactive SQL [dbisql], the Debugger utility [dbprdbg], the Language utility [dblang], and the Console utility [dbconsole] accept the @filename parameter. The filename 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 switches. The @file syntax is not supported within a file.
@file parameters will be left untouched if they occur after the -w switch. This can be useful, for example, if you want to use the Service Creation utility [dbsvc] and to create a service where the server (or MobiLink) reads the parameter file itself.
The following reads all parameters from dbinit.in
dbinit @dbinit.in
The following example is the same as dbinit -q -ja -p 2048 -b new.db
echo "-ja -p 2048" > dbinit.in dbinit -q @dbinit.in -b new.db
In the following example, dbsvc_parms will be read by dbsvc, but dbsrv_parms will not. The service will be created with the command line dbsrv9.exe @dbsrv_parms.
dbsvc @dbsvc_parms -w mysvc dbsrv9.exe @dbsrv_parms
The following command 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:\Program Files\Sybase\SQL Anywhere 9\asademo.db"
If this configuration file is saved as c:\config.txt, it can be used in a command as follows:
dbsrv9 @c:\config.txt
The following command file contains comments:
#This is the server name: -n MyServer #These are the protocols: -x tcpip #This is the database file my.db