Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only.

Join the TIBCO Community
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.


Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] FORMAT SQLORA

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[SOLVED] FORMAT SQLORA
 Login/Join
 
MattC
Guru
posted
I am pulling and writing data to an Oracle table with a procedure using

 
ON TABLE HOLD AS &TempTableName FORMAT SQLORA


My question is, Does this pull the data back to the Reporting Server and then send it back to Oracle? I was thinking there is some syntax to keep all the processing on Oracle, but I can't remember if it's in Webfocus or in Oracle. I am using SQL Pass-thru to do this.

This message has been edited. Last edited by: MattC,


WebFOCUS 8.1.05
 
Posts: 496 | Registered: January 04, 2008Report This Post
dhagen
Virtuoso
posted Hide Post
On table hold means Oracle->WFRS->Oracle.

If you want Oracle only, then use pass-thru.


"There is no limit to what you can achieve ... if you don’t care who gets the credit." Roger Abbott
 
Posts: 1102 | Location: Toronto, Ontario | Registered: May 26, 2004Report This Post
MattC
Guru
posted Hide Post
Thanks Dhagen. I think I will just do that. Do a INSERT with a SELECT statement.


WebFOCUS 8.1.05
 
Posts: 496 | Registered: January 04, 2008Report This Post
David Briars
Master
posted Hide Post
quote:
...I was thinking there is some syntax to keep all the processing on Oracle...

I've been kicking the tires on FORMAT SAME_DB.

Maybe that is what you are thinking of?

We are using the Oracle Adapter too.

So far it looks promising, and is working fine.

Doing a SQL trace I can see the WF generated Oracle SQL SELECT/INSERT, along with a CREATE GLOBAL TEMPORARY TABLE...

I've subsequently joined to/from the temporary table to/from a regular Oracle table, with the join effective on the Oracle side AOK.

I am not a SAME_DB/GTT geek, so if anyone has any thoughts/experiences, I'd be all ears.

This message has been edited. Last edited by: David Briars,




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
 
Posts: 822 | Registered: April 23, 2003Report This Post
Waz
Expert
posted Hide Post
I've used SAME_DB, and it does work, and all processing is on ORACLE.

But we found an issue with HOLD FORMAT SAME_DB PERSISTENCE GLOBAL_TEMPORARY, when used twice in the same proc. The second table ended up empty. There is a case and it is in Product division.


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

 
Posts: 6347 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 2006Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] FORMAT SQLORA

Copyright © 1996-2020 Information Builders