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.
New TIBCO Community Coming Soon
In early summer, TIBCO plans to launch a new community—with a new user experience, enhanced search, and expanded capabilities for member engagement with answers and discussions! In advance of that, the current myibi community will be retired on April 30. We will continue to provide updates here on both the retirement of myibi and the new community launch.
What You Need to Know about Our New Community
We value the wealth of knowledge and engagement shared by community members and hope the new community will continue cultivating networking, knowledge sharing, and discussion.
During the transition period, from April 20th until the new community is launched this summer, myibi users should access the TIBCO WebFOCUS page to engage.
Please can any one help me in transferring data from one maintain procedure(.mnt) to another(.mnt) in the same project in Update records case.This message has been edited. Last edited by: <Kathryn Henning>,
The Maintain command to have one Maintain perform another Maintain is CALL. You can CALL one Maintain from another and pass stacks of data between them. You just have to remember to INFER the stack in the CALLd Maintain. An example would be:
-* Maintain1 MAINTAIN FILE Movies For ALL Next Moviecode into MOVSTK CALL Maintain2 from MOVSTK END
-Maintain2 MAINTAIN FILE Movies from MOVSTK Infer Moviecode into MOVSTK -* Now you can use the data that was loaded into the MOVSTK in Maintain1 END
Mark
Posts: 663 | Location: New York | Registered: May 08, 2003
You can CALL from multiple stacks and simple variables.
The items that MUST match in the call and receiving Maintain Commands: Number of items Sequence of items Data Types Stack Column Names
The items that need not match: Stack and variable names Length and precision
If a single Stack cell is passed, it must be received as a simple variable. You cannot pass variables or stacks using A0 or Stack of formats. Stacks and variables can be passed back using the INTO option, FROM Stacks and variables are not passed back and remain unchanged in the host process.
Alan. WF 7.705/8.007
Posts: 1451 | Location: Portugal | Registered: February 07, 2007
So, as Alan points out, multiple stacks can be passed to and from a CALL'd procedure from the parent. Just list them on the CALL command line...
-* Maintain1 MAINTAIN FILE Movies For 10 Next Moviecode into MOVSTK1 For 10 Next Moviecode into MOVSTK2 For 10 Next Moviecode into MOVSTK3
CALL Maintain2 from MOVSTK1 MOVSTK2 MOVSTK3 END
-Maintain2 MAINTAIN FILE Movies from MOVSTK1 MOVSTK2 MOVSTK3 Infer Moviecode into MOVSTK1 Infer Moviecode into MOVSTK2 Infer Moviecode into MOVSTK3 -* Now you can use the data that was loaded into the MOVSTK1, NOVSTK2 and MOVSTK3 in Maintain1 END
Mark
Posts: 663 | Location: New York | Registered: May 08, 2003
I absolutely agree with Alan that taking Maintain training is the best way to learn how to use the product. Having said that, you can use up to 15 different data sources with the Maintain product. Each stack can contain one database path. So...
-* Maintain1 MAINTAIN FILE Movies AND CAR For 10 Next Moviecode into MOVSTK1 For ALL Next Country Car into CARSTK1
CALL Maintain2 from MOVSTK1 CARSTK1 END
-Maintain2 MAINTAIN FILE Movies AND CAR from MOVSTK1 CARSTK1 Infer Moviecode into MOVSTK1 Infer Country Car into CARSTK1 -* Now you can use the data that was loaded into the MOVSTK1 and CARSTK1 in Maintain2 END
Mark
Posts: 663 | Location: New York | Registered: May 08, 2003