Install Stored Procedures

SAP jConnect to function properly, you must install stored procedures and tables on the SAP Adaptive Server or SAP SQL Anywhere database to which your application is connecting.

SAP jConnect provides these scripts to install the required stored procedures and tables:

sql_server.sql – installs stored procedures on SAP Adaptive Server earlier than version 12.0.
sql_server12.sql – installs stored procedures on SAP Adaptive Server 12.0.x.
sql_server12.5.sql – installs stored procedures on SAP Adaptive Server 12.5.x.
sql_server15.0.sql – installs stored procedures on SAP Adaptive Server 15.0.x through 15.5.x.
sql_server15.7.sql – installs stored procedures on SAP Adaptive Server 15.7 or 15.7 ESD #1.
sql_server15.7.0.2.sql – installs stored procedures on SAP Adaptive Server 15.7 ESD #2 or later.
sql_server16.0.sql – installs stored procedures on SAP Adaptive Server 16.0.
sql_asa.sql – installs stored procedures on SAP SQL Anywhere 9.x.
sql_asa10.sql – installs stored procedures on SAP SQL Anywhere 10.x.
sql_asa11.sql – installs stored procedures on SAP SQL Anywhere 11.x.
sql_asa12.sql – installs stored procedures on SAP SQL Anywhere 12.x.
sql_asa16.sql – installs stored procedures on the SAP SQL Anywhere database version 16.x.

Running Stored Procedure Installation Scripts

Verify that your JAVA_HOME, JDBC_HOME, and CLASSPATH environment variables are set.
Use the IsqlApp sample application.

Installing Stored Procedures on SAP Adaptive Server Database

Go to the (Windows) %JDBC_HOME%\classes (UNIX) $JDBC_HOME/classes directory from the prompt window and enter:

For SAP Adaptive Server Enterprise version 16.x:

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

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

Note: The sql script to be used is dependent on the SAP ASE version. See Install Stored Procedures for a list of scripts available.

Installing Stored Procedures on a SAP SQL Anywhere Database

For Microsoft Windows – Go to %JDBC_HOME%\classes directory and enter:

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

For UNIX platforms – Go to $JDBC_HOME/classes directory and enter:

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