On a SQL Anywhere or Adaptive Server Anywhere database

The following describes how to install stored procedures for metadata in a SQL Anywhere or Adaptive Server Anywhere database using Windows, UNIX, and Linux.

StepsInstalling stored procedures on Windows

  1. Go to a DOS prompt

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

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

StepsInstalling stored procedures on UNIX and Linux

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

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