Executing the script

At this point, you can execute the DDL script in Interactive SQL and create database objects in the VLDBServer database.

  1. Start the VLDB database server, if the server is not already running. To do this, change to the directory that contains the database files and use the following command format:

    start_asiq -n server_name @config_file.cfg database_name.db
    

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

    NoteNote 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 the following command at the operating system prompt to start Interactive SQL Java:

    dbisql
    
  3. Enter the correct User ID, Password, and server information in the dbisql Connect dialog box.

  4. Open the generated DDL script for IQ and click the Execute SQL statement button on the Interactive SQL toolbar to execute the script.