Editing the script  Appendix A: SQL Scripts for Sample Queries

Chapter 4: Generating DDL Scripts

Executing the script

At this point, you can execute the DDL script in Interactive SQL and create database objects in the RAP cache database. These instructions apply to UNIX platforms.

  1. At the operating system prompt, enter the command:

    isql -Sserver_name -Uuser_name -Ppassword -iase_ddl.sql -ologfile

    If the Adaptive Server Enterprise server is not running, start the server as described in the Adaptive Server Enterprise Utility Guide.

  2. Check the log file for errors.




Copyright © 2005. Sybase Inc. All rights reserved. Appendix A: SQL Scripts for Sample Queries

View this book as PDF