Many of the utilities provided with SQL Anywhere 12 allow you to store command-line options in a configuration file. If you use an extensive set of options, you may find it useful to store them in a configuration file.

The @data option allows you to specify environment variables and configuration files on the command line. To specify a configuration file, replace data with the path and name of the configuration file. If both an environment variable and configuration file exist with the same name, the environment variable is used.

Configuration files can contain line breaks, and can contain any set of options, including the @data option. You can use the number sign (#) at the beginning of a line to designate the line as a comment. The ampersand (&) character appearing by itself at the end of a line indicates that the previous token is continued on the next line. For example, the following configuration file could be used to start a server that allows strong encryption:

-ec TLS(TLS_TYPE=RSA;FIPS=Y;IDENTITY=rsaserver.id; &
     IDENTITY_PASSWORD=test)
 -x tcpip c:\mydemo.db

The @data parameter can occur at any point in the command line, and parameters contained in the file are inserted at that point. You can use @data multiple times on one command line to specify multiple configuration files.

Utilities read the command line by expanding the specified configuration files and reading the entire command line from left to right. If you specify options that are overridden by other options in the command line, the option closer to the end of the line wins. Conflicting options can cause errors.

If you want to protect passwords or other information in a configuration file, you can use the File Hiding utility to obfuscate the contents of the configuration file. See File Hiding utility (dbfhide).

 Configuration file escape characters

-l "subject=$remote_id;
    content=sync cardealer;
    action='run dbmlsync.exe -c \"filedsn=c:\my fdsns\CarDealer.dsn\"
    -ot dbmlsync.log -k -e sa=on';"

 Example

#Connect to the sample database as the user DBA with password sql
-c "UID=DBA;PWD=sql;DBF=%SQLANYSAMP12%\demo.db"
#Perform an express check on each table
-fx
#Log output messages to the specified file
-o "c:\validationlog.txt"

dbvalid @c:\config.txt