Executing the Deployment Script Using the SAP Adaptive Server isql Utility

To execute the commands from the deployment script file, use the isql utility included in the Open Client™ installer that is part of the SAP Replication Server media.

Prerequisites

Before executing a deployment script using the isql utility, modify the command terminators in the script. By default, isql uses go as the command terminator, whereas the Replication Agent for SAP HANA saves script files using the line character as the command terminator. The isql utility does not allow line control characters as command terminators.

Task

The isql utility is a command line interactive SQL parser to SAP® Adaptive Server® Enterprise. For more information about the isql utility, see the SAP Adaptive Server Enterprise Utility Guide.

Use a text editor to change the script to use the default isql command terminator.
For example, change these lines from:
```
call ra_add_prop(driverName, com.sap.db.jdbc.Driver)
call ra_deploy()
```
to:
```
call ra_add_prop(driverName, com.sap.db.jdbc.Driver)
go
```
```
call ra_deploy()
go
```
Save the script.
Execute the script from the isql command line.
For example:
```
isql -Usa -PSybase123 -SMY_RAX_CONTAINER < c:\Sybase\Scripts\MyDeployScript.sql
```
In this example:
- sa – is the user ID.
- Sybase123 – is the password for your container.
- MY_RAX_CONTAINER – is the server name.
Servers are defined in the sql.ini file. The c:\Sybase\Scripts\MyDeployScript.sql is the deployment script file.