Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] Can MODIFY work on clustered relational tables
Go
New
Search
Notify
Tools
Reply
  
[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: 40 | Location: Denver, CO | Registered: March 16, 2005Reply With QuoteReport 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.0.1M gen 240, Dev 8.2.04 gen 48, OS : Windows, DB : MSSQL, Outputs : HTML, Excel, PDF
In Focus since 2007
 
Posts: 2107 | Location: Montreal Area, Qc, CA | Registered: September 25, 2013Reply With QuoteReport 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?




Test: WebFOCUS 8.1.05M Prod: WebFOCUS 8.1.05M Server: Windows Server 2012/Tomcat Standalone Workstation: Windows 7/IE 11 Database: Oracle 12c/Netezza Output: AHTML/XLSX/HTML/PDF/JSCHART Tools: WFDS, Repository Content, BI Portal Designer, & ReportCaster

 
Posts: 760 | Registered: April 23, 2003Reply With QuoteReport 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.05OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Know The Code

 
Posts: 6072 | Location: Land of the Darug people, Terra Australis Incognita | Registered: October 31, 2006Reply With QuoteReport 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: 40 | Location: Denver, CO | Registered: March 16, 2005Reply With QuoteReport 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: 659 | Location: New York | Registered: May 08, 2003Reply With QuoteReport 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.05OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Know The Code

 
Posts: 6072 | Location: Land of the Darug people, Terra Australis Incognita | Registered: October 31, 2006Reply With QuoteReport This Post
  Powered by Social Strata  
 

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-2018 Information Builders, leaders in enterprise business intelligence.