On an Adaptive Server Enterprise database

The following describes how to install stored procedures for metadata in an Adaptive Server Enterprise database using Windows, UNIX, and Linux.

1. Go to a DOS prompt

2. Enter the following command on one line from the %JDBC_HOME%\classes directory:

   • For Adaptive Server Enterprise version 15.x:

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

   • For 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
     

1. Enter the following command from your $JDBC_HOME/classes directory:

   • For Adaptive Server version 15.x:

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

   • For Adaptive Server 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