Installing datatype definitions

You must execute a SQL script in the RSSDs of both the primary Replication Server and the replicate Replication Server to install datatype definitions. The script inserts in the RSSD rs_datatype table datatype definitions for the replicate database datatypes.

Installing datatype definitions in the RSSD

Sample installation scripts are provided for each non-Sybase database supported by HDS. The following databases are supported by HDS in Replication Server version 12.6, and the datatype definition installation script for each database.

Table 8-1: Datatype definition installation scripts
Database

Script

Adaptive Server Anywhere

hds_asa_udds.sql

DB2

hds_db2_udds.sql

Informix

hds_informix_udds.sql

Microsoft SQL Server

hds_msss_udds.sql

Oracle

hds_oracle_udds.sql

UDB

hds_udb_udds.sql

You must execute the appropriate script for your replicate database type.

**Table 8-1: Datatype definition installation scripts**
Database	Script
Adaptive Server Anywhere	hds_asa_udds.sql
DB2	hds_db2_udds.sql
Informix	hds_informix_udds.sql
Microsoft SQL Server	hds_msss_udds.sql
Oracle	hds_oracle_udds.sql
UDB	hds_udb_udds.sql

Find the script you need for your replicate database, then edit the script by adding the following command line after the initial comments, where rssd is the name of the RSSD database:
```
use rssd
```
Log in to the RSSD data server or a machine with a network connection to the RSSD host machine using a user ID with owner permission in the RSSD database.

In this procedure, isql is used as the Open Client application to access the RSSD database. You can use any Open Client application to access the RSSD database.
Use the following command at the operating system prompt to execute the datatype definition installation script:
```
isql -Uuser -Ppw -Sserver -Drssd -iscript_name
```
where:
- user – is the user ID with owner permission in the RSSD.
- pw – is the password for the user ID.
- server – is the server name of the RSSD host machine.
- rssd – is the database name of the RSSD.
- script_name – is the name of the datatype definition installation script file that you edited.
You must repeat this procedure for both the primary Replication Server RSSD and the replicate Replication Server RSSD. You can also install datatype definitions in any other Replication Server RSSD in your replication system with no performance penalty.