WSO Federated query support

Document ID : KB000110205
Last Modified Date : 09/08/2018
Show Technical Document Details
Introduction:
CA Repository for z/OS Webstation Option r7.2 does not support creating
search objects with federated queries which run against multiple  
RDBMSs and\or database hosts.                                     
                                                                  
Ability to run federated queries extends the existing feature,    
Remote database connectivity offered by WSO to run multiple       
queries from single search object.                                
Instructions:
Download and apply solution SO01673.


 
Additional Information:
Make sure to use the new WSOServerProperties.xml which includes new parameters for some other enhancements which were resolved earlier and support for Type 4 driver to connect to DB2 as a remote RDBMS. 
 
This new build is enhanced to support
  • con-current execution of search objects by multiple users and
  • multiple dynamic Filters (WHERE clauses) option
 Make sure to specify the port value in the WSOServerProperties.xml. Database, host and credentials need to be specified in the search object.
Staging tables need to exist in the repository before search object can be executed.  Users need to create staging tables.
Staging table must contain all column names specified in SELECT clause of corresponding SELECT query.
All such columns should have column names, data types, lengths matching with respective values in the source table.
 
Federated Search object(s) cannot have SP calls; only SELECT statements are allowed.
User can connect to RDBMSs which are supported by Remote RDBMS feature.
 
Every SELECT statement except the last, should follow associated CONNECT statement and SELECT itself should be followed by STAGING_TABLE statement.
 
The last query in the search object is considered as a JOIN query and is always executed against the database which contains repository (and staging tables).
CONNECT and STAGING_TABLE are not required here and are ignored if specified.