I am trying to create a join between two synonyms that each describe an external SQL query, on separate database connections. Both connections are MSSQL 2008 adapters. Report can be created from each synonym individually with no problems. However, a join attempt produces an FOC1406 SQL OPEN CURSOR ERROR.
Error is produced whether attempting the join in the report (via IA+) or creating the join in a clustered synonym.
If the synonyms are regular table descriptions (i.e. not from external SQL query), the join works correctly.
I have SUBQUERY=Y in the access file for each synonym. SQL Trace output confirms that Focus-managed join is enabled.
Is this scenario supported in BUE? Any help, info, or reference documentation would be appreciated.
The dynamic join will not work with external SQL synonyms. Try creating a report in IA+ using these steps:
Refer to the online help topic: Creating Content -> Creating Hold Files
Hope this helps.
Richard SittThis message has been edited. Last edited by: Richard Sitt,
Thanks for the information, Richard. Which file format should the HOLD file be saved in?
Windows, All Outputs
Binary format is fine. As for location, put it in the application directory that matches your domain name.
|Powered by Social Strata|