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     [CLOSED] Can MODIFY work on clustered relational tables

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[CLOSED] Can MODIFY work on clustered relational tables
 Login/Join
 
Gold member
posted
I assumed that I could code MODIFY to insert records into a clustered relational table structure (just a parent and child), but I haven't been successful in inserting records into more than a single table. I could swear that you could do this, but I can't find any discussions or examples which show how it's done.

Of course MODIFY was for FOCUS databases originally, so the documentation (yes, I found it) doesn't provide examples for working with clustered RDMS tables.

Does anyone know if this is even possible? SQL pass through is not an option in this situation, nor is Maintain.

Thanks

This message has been edited. Last edited by: FP Mod Chuck,


Local: AppStudio 8.2.03 - Win7 - Tomcat Server: WebFOCUS 8.2.03 - Windows 2008 R2 Enterprise on VMWare 2 CPU, 3.2GHz, 4GB of RAM Output Formats: HTML, Excel, PDF, PPT, Active Reports
 
Posts: 38 | Location: Denver, CO | Registered: March 16, 2005Report This Post
Virtuoso
posted Hide Post
I am not giving you an answer but instead asking you something and raise a point of discussion.

Bottom line, any FOCUS, Maintain or MODIFY command is translated into SQL syntax to then be performed.
So, if it's not possible to use SQL pass through, why MODIFY should be ?


WF versions : Prod 8.2.04M gen 33, Dev 8.2.04M gen 33, OS : Windows, DB : MSSQL, Outputs : HTML, Excel, PDF
In Focus since 2007
 
Posts: 2409 | Location: Montreal Area, Qc, CA | Registered: September 25, 2013Report This Post
Master
posted Hide Post
When I was using MODIFY to update more than one FOCUS DB we used the COMBINE facility.

While I've used MODIFY TO update one relational table, I've never had to update more than one table in the same MODIFY.

If MODIFY can support updating more than one relational table it is possible IB used the COMBINE facility to do this.

If your doc discusses COMBINE, perhaps it might be worthwhile testing?




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
Expert
posted Hide Post
As a clustered master is multi segment my guess is yes.

You will have to navigate the segments to get to where you want to be. Either via MATCH {fld list} or MATCH {flds}... CONTINUE MATCH {flds} etc


Paraphrasing Toto
"Hoping to find some long forgotten words or ancient memories"


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
Gold member
posted Hide Post
quote:
Originally posted by MartinY:
So, if it's not possible to use SQL pass through, why MODIFY should be?


I should have clarified...SQL pass through is not allowed in this particular environment. I don't know the reason, just that it's not allowed. So that leaves me with figuring out how to use MODIFY to insert records.


Local: AppStudio 8.2.03 - Win7 - Tomcat Server: WebFOCUS 8.2.03 - Windows 2008 R2 Enterprise on VMWare 2 CPU, 3.2GHz, 4GB of RAM Output Formats: HTML, Excel, PDF, PPT, Active Reports
 
Posts: 38 | Location: Denver, CO | Registered: March 16, 2005Report This Post
Master
posted Hide Post
Maintain can easily update up to 15 tables in one procedure. If you need assistance coding this I will be happy to help.

Mark Derwin
 
Posts: 663 | Location: New York | Registered: May 08, 2003Report This Post
Expert
posted Hide Post
For Modify, this may help

WebFOCUS Modify Reference


Are you going to do the update via App Studio ? or on the server ?


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     [CLOSED] Can MODIFY work on clustered relational tables

Copyright © 1996-2020 Information Builders