Use the using profile clause with the create connection command to create a connection between a non-ASE database and Adaptive Server using a connection profile.
Here is a portion of the create connection syntax that shows the using profile and display_only clauses:
create connection to data_server.database using profile connection_profile;version set username [to] user [other_create_connection_options]] [display_only]
create connection to oracle.instance using profile rs_ase_to_oracle;standard set username to ora_maint set password to ora_maint_pwd
create connection to msss_server.msss_db using profile rs_ase_to_msss;standard set username to msss_maint set password to msss_maint_pwd set error class to my_msss_error_class with log transfer on
create connection to db2.subsys using profile rs_ase_to_db2;v9_1 set username to db2_maint set password to db2_maint_pwd set dsi_cmd_batch_size to ‘16384’
create connection to oracle.instance using profile rs_ase_to_oracle;standard set username to ora_maint set password to ora_maint_pwd display_only
go
For more information about create connection, see the Replication Server Reference Manual.