Just checking: Is this a documented and supported feature of WebFOCUS 7? I'm sure it is in WebFOCUS 8, right?This message has been edited. Last edited by: Doug,
In FOCUS Since 1983 ~ from FOCUS to WebFOCUS. Current: WebFOCUS Administrator at FIS Worldpay | 8204, 8206
September 15, 2014, 06:02 PM
Waz
As far as I know. Yes.
Keep in mind that behind the scenes, queries will be sent to both servers and pull data for local joining.
If they are large tables you may bring back many records.
Waz...
Prod:
WebFOCUS 7.6.10/8.1.04
Upgrade:
WebFOCUS 8.2.07
OS:
Linux
Outputs:
HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!
September 15, 2014, 06:16 PM
David Briars
Our cross-platform joins (Oracle to Netezza) from 7.7.02 continued to work, as we migrated to 8.0.07.
+1 to Waz's caveats.
Pilot: WebFOCUS 8.2.06 Test: WebFOCUS 8.1.05M Prod: WebFOCUS 8.1.05M Server: Windows Server 2016/Tomcat Standalone Workstation: Windows 10/IE11+Edge Database: Oracle 12c, Netezza, & MS SQL Server 2019 Output: AHTML/XLSX/HTML/PDF/JSCHART Tools: WFDS, Repository Content, BI Portal Designer & ReportCaster
September 16, 2014, 10:19 AM
Francis Mariani
You can join a table or file of one of 80 or so types to a table or file of another type, but that doesn't mean it's necessarily a good idea. Turn on SQL traces and you'll see why (as Waz mentioned). This can occur even if the two tables are of the same type but on different servers or accessed from different data adapter connections.
Francis
Give me code, or give me retirement. In FOCUS since 1991
Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
September 16, 2014, 10:41 AM
Tony A
Doug,
Have you thought about using OPENQUERY? Look for it on MSDN.
The basic syntax is OPENQUERY ( linked_server ,'query' ).
T
In FOCUS since 1986
WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2
WebFOCUS App Studio 8.2.06 standalone on Windows 10
September 16, 2014, 12:52 PM
Doug
Thanks everyone... I'll also consider the OPENQUERY We'er in the process of going live with 8004.
We'er in the process of going live with 8004.