Specifies the target database file for a load or connection, when starting
a database.
To connect to an already running database, use the DatabaseName (DSN) parameter.
SAP Sybase IQ requires the DBF parameter and the database
file name to connect under special circumstances.
Description
DBF loads and connects to a specific database file that is not already running on
a database server.
- If a database is loaded with a name that is the same as the
DatabaseFile parameter, but without the .db
extension, the connection is made to that database instead.
- If the file name does not include an extension, a file of
name .db is looked for.
- The path of the file is relative to the working directory of the
database server. If you start the server from the command prompt, the working
directory is the directory you are in when you enter the command. If you start
the server from an icon or shortcut, it is the working directory specified in
the icon or shortcut. It is recommended that you supply a complete path and file
name.
- If you specify both the database file and the database name, the
database file is ignored and is not used to try to connect to a database that is
already running.
You can also use UNC file names.
Warning! The database file must be on the same machine as the database
server. Managing a database file that is located on a network drive might lead to
file corruption.
Example
To load and connect to the demo database (installed in directory
C:\Program Files\Sybase\IQ-16_0\demo
on Windows), use the following DBF parameter:
DBF=C:\Program Files\Sybase\IQ-16_0\demo\iqdemo.db