CA TPX Session Management for z/OS

Repository Tip: Long Connect Strings in WebStation Option 

12-02-2014 05:54 PM

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;

Statistics
0 Favorited
0 Views
0 Files
0 Shares
0 Downloads

Tags and Keywords

Related Entries and Links

No Related Resource entered.