Install stored procedures  On a SQL Anywhere or Adaptive Server Anywhere database

Chapter 1: Installation Instructions

On an Adaptive Server Enterprise database

To install stored procedures for metadata in an Adaptive Server Enterprise database using Windows, go to a DOS prompt and enter the following command on one line from the %JDBC_HOME%\classes directory:

Adaptive Server Enterprise version 12.5.x:

java IsqlApp -U sa -P password -S jdbc:sybase:
 	Tds:[hostname]:[port] -I %JDBC_HOME%\sp\sql_server12.5.sql -c go

Adaptive Server Enterprise version 12.0:

java IsqlApp -U sa -P password -S jdbc:sybase:
 	Tds:[hostname]:[port] -I %JDBC_HOME%\sp\sql_server12.sql -c go

Adaptive Server Enterprise version 11.9.2 and earlier:

java IsqlApp -U sa -P password -S jdbc:sybase:
 	Tds:[hostname]:[port] -I %JDBC_HOME%\sp\sql_server.sql -c go

On UNIX or Linux, enter the following command from your $JDBC_HOME/classes directory:

Adaptive Server Enterprise version 12.5.x:

java IsqlApp -U sa -P password -S jdbc:sybase:
 	Tds:[hostname]:[port] -I $JDBC_HOME/sp/sql_server12.5.sql -c go

Adaptive Server Enterprise version 12.0:

java IsqlApp -U sa -P password -S jdbc:sybase:
 	Tds:[hostname]:[port] -I $JDBC_HOME/sp/sql_server12.sql -c go

Adaptive Server Enterprise version 11.9.2 and earlier:

java IsqlApp -U sa -P password -S jdbc:sybase:
 	Tds:[hostname]:[port] -I $JDBC_HOME/sp/sql_server.sql -c go



Copyright © 2003. Sybase Inc. All rights reserved. On a SQL Anywhere or Adaptive Server Anywhere database

View this book as PDF