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     Adding rows to a hold file

Read-Only Read-Only Topic
Go
Search
Notify
Tools
Adding rows to a hold file
 Login/Join
 
OlafMeyer
Member
posted
Hello,

I hope there is an easy solution for my problem. I'm creating a hold file that is going to be used to populate the options on a HTML page. The options are calculated from two values (country and company name). In addition each country should have three default options. Is there a simple way to create these rows without creating three hold files.

Thank you very much,

Olaf
 
Posts: 5 | Registered: April 26, 2006Report This Post
susannah
Expert
posted Hide Post
using the MORE option might be just what you need. it allows you to read a bunch of hold files or text files or whatever into a merged entity. The way JOIN merges horizontally, MORE merges vertically.
TABLE FILE CAR
PRINT CAR COUNTRY
ON TABLE HOLD AS MYOUTPUT
MORE
FILE OTHERCAR
MORE
FILE KIDSCARS
END.
now the file MYOUTPUT will have all 3 bits together.
The field names referenced in the first part of that paragraph will be the same fieldnames referenced when reading the subsequent files.
The 3 files don't have to be identical, but must contain the same referenced fields in the same format. IF statements, if any, would need to be applied to each file individually.
2.you can also read a flat file and then add and/or reorganize records to it, using
-READ
and
-WRITE syntax.
( i use this to create javascript arrays for inclusion in my .asp launch pages)
3. then there's FILEDEF...APPEND syntax
A zillion ways to do stuff with this way cool language.



In Focus since 1979///7706m/5 ;wintel 2008/64;OAM security; Oracle db, ///MRE/BID
 
Posts: 3811 | Location: Manhattan | Registered: October 28, 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     Adding rows to a hold file

Copyright © 1996-2020 Information Builders