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     How to update multi-path with Maintain?

Read-Only Read-Only Topic
Go
Search
Notify
Tools
How to update multi-path with Maintain?
 Login/Join
 
Charlotte
Member
posted
We are trying to update two separate paths of data with one Maintain program. I know we need two separate stacks, but the developer can not get the second path of data to update at all. Can anyone out there provide any suggestions?

Our PM has suggested redesigning the database (which will be extremely inefficient) in order to eliminate the problem, but as the DBA I would certainly hope that Maintain can do multi-paths.

PLEASE HELP
Charlotte


Cha
 
Posts: 1 | Registered: November 29, 2005Report This Post
Maintain Wizard
Master
posted Hide Post
Hi Charlotte
In order to update multiple paths, you need to have multiple stacks and the keys to ALL of the parent segments need to be populated. For example, with the CAR file, to cover all the segments, you would need:

INFER COUNTRY CAR MODEL BODYTYPE SPECS INTO STK1
INFER COUNTRY CAR WARRENTY INTO STK2
INFER COUNTRY CAR STANDARD INTO STK3

In order to update the entire file you would have to populate the COUNTRY and CAR segments for all of the stacks and then populate the other segments for each of the stacks.

I believe, in your case, TLOGSTK does not contain all of the date for the DESCDATA segment before you are updating. It is easy to test this. Before the update statement, print out all of the key fields for all 3 segments.. Make sure they are all populated.

Mark Derwin
 
Posts: 663 | Location: New York | Registered: May 08, 2003Report This Post
Maintain Wizard
Master
posted Hide Post
Charlotte
I just reviewed the code that you are using to update multiple paths in the Master and here is the problem.

You have create a stack from the data base, and added computed fields in the stack with the same names as the fields in the other segment. This is one way of getting around the multi-path issue. However, in this case you cannot use the COPY command to move fields from one stack to the other. You must create a loop and COMPUTE the data in. This is because, while the new computed fields in the stack have the same name and format as the database fields, they are not actually the database fields. So create a loop, and compute the values from one stack to the other.

Mark
 
Posts: 663 | Location: New York | Registered: May 08, 2003Report 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     How to update multi-path with Maintain?

Copyright © 1996-2020 Information Builders