Installing Stored Procedures

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

SAP jConnect includes these scripts for installing 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 later.
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.

Note: If you use SAP Adaptive Server 12.5.3 or later, or SAP Adaptive Server Anywhere 9.0.2 or later, the scripts come preinstalled on the server. Install these scripts only if you have a later version of the driver than the one that shipped with SAP Adaptive Server. In addition, for backward compatibility, sql_server.sql and sql_server12.sql are included on SAP Adaptive Server 11.9.2 and 12.0 respectively, although these versions are no longer supported.