Executing DDL Scripts

Execute the DDL script in Interactive SQL and create database objects in the RAPStore database.

  1. If the RAPStore database server is not already running, start it:
    1. Change to the directory that contains the database files.
    2. Use the following command format:start_asiq -n server_name @config_file.cfg database_name.db.

    Use the -n switch to name the server, either in the configuration file or on the command line when you start the server.

    Note:

    If you specify -n server_name without a database_name, you connect to the default database on the current server. If you specify -n database_name without a server_name, you connect to the specified database on the current server.

  2. Enter dbisql
  3. Enter the correct user ID, password, and server information.
  4. Open the generated DDL script for IQ and click Execute SQL Statement on the toolbar to execute the script.


Created March 26, 2009. Send feedback on this help topic to Sybase Technical Publications: pubs@sybase.com