Connection profiles allow you to configure your connection with a pre-defined set of properties by setting the function-string class and error class, installing the user-defined datatypes (UDD) and translations for Sybase IQ, and creating the tables required for replication in the replicate Sybase IQ database.
The rs_ase_to_iq connection profile is included as part of the Replication Server installation package and it is registered when you install Replication Server. The connection profile:
Customizes function strings, error classes, and user defined datatypes.
The function string replaces several default Replication Server function strings with custom function strings designed to communicate with a Sybase IQ data server and access the tables and procedures. These function strings are added to the Replication Server default rs_iq_function_class. RTL treats customized function strings as non-compilable commands.
Customizes class-level datatype translations
Class-level translations identify primary datatypes and the replicate datatypes the data should be translated into. Class-level translation is supplied for the Sybase IQ replicate database by the rs_ase_to_iq connection profile which translates Adaptive Server datatypes to Sybase IQ datatypes
Creates tables in the Sybase IQ replicate database – rs_threads, rs_lastcommit, and rs_ticket_history tables.
Sets connection properties – the default function-string class and error class to configure the connection to Sybase IQ:
set error class rs_iq_error_class set function string rs_iq_function_class
Create the connection to the replicate Sybase IQ database using create connection with the using profile clause, and specify your replicate Sybase IQ data server and database.
See “create connection with using profile clause,” in Chapter 3, “Replication Server Commands” in the Replication Server Reference Manual.
Use admin who to verify the connection is created and Replication Server connects successfully to Sybase IQ.