A search object in WebStation Option can connect to another relational database management system (RDBMS) such as Oracle or MS SQL server.
The rules for connecting to another RDBMS in a search object are:
� The search object must specify a WSO Connect command as follows:
{RDBMS_Code*Driver_suffix}connect#[hostname]#[Database Name]#[userid]#[password];
[Query to be executed]
For more information regarding each field that makes up the connect string, refer to page 135 'Rules for Connecting to Other RDBMS Databases' in the CA Repository WebStation Option Administration Guide r7.2.
In order to be able to use a Connect string that spawns across two lines, the first line should end with # sign
For example,
The following string takes the first line as far as it can go and ends up breaking the password field in half. This will result in a connection failure.
=COLS>---------------------------------------------------------------------------------------------------------------------------80
000001 {02*0}CONNECT#SERVER1.MYDMN.COM#DATABASE1#CAREPOSITORYLONGUSERNAMEORACLE#REPOS
000002 ITORYDBA15;
000003 SELECT ID, NAME
000004 FROM CAREPOSITORYLONGUSERNAMEORACLE.MYORACLE;
In the next example, I took the first line as far out as possible while ending with the #. Any remaining fields will begin on the next line.
This successfully connects and retrieves the result set.
=COLS>-----------------------------------------------------------------------------------------------------------------------------80
000001 {02*0}CONNECT#SERVER1.MYDMN.COM#DATABASE1#CAREPOSITORYLONGUSERNAMEORACLE#
000002 REPOSITORYDBA15;
000003 SELECT ID, NAME
000004 FROM CAREPOSITORYLONGUSERNAMEORACLE.MYORACLE;