You can start databases when you start the server, or after the server is running. To start a database when you start the server, see “Starting the database server” for details.
Sybase recommends that you run only one database per server, especially in a production environment.
There are several ways to start a database on a running server.
To start a database from Interactive SQL or Embedded SQL, use the START DATABASE statement. See STOP DATABASE statement [DBISQL] in Reference: Statements and Options.
To start and connect to a database from Interactive SQL or Sybase Central, use a data source that specifies the database file. See “Working with ODBC data sources”.
To start and connect to a database when you start Interactive SQL from a system command prompt, include the parameter “DBF=db-file” in the connection parameters. See “Connecting to the demo database from Sybase Central or Interactive SQL”
To start a database from Sybase Central, see Chapter 4, “Managing Databases,” in Introduction to Sybase IQ
To start an embedded database, while connected to a server, connect to a database using a DBF parameter. This parameter specifies a database file for a new connection. The database file is loaded onto the current server.
