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.



Read-Only Read-Only Topic
Go
Search
Notify
Tools
Tables Manipulation
 Login/Join
 
L_G
Gold member
posted
Hi All,

Sorry about the question but I am new in the Developer Studio...

Do you now how I can manipulate the tables (mas files)? I need to iterate through the tables data, to create new tables and so on...

Currently I am reading the Maintain documentation but I still do not know whether it will help me.

Can somebody help me?

Thanks in advance!


WebFOCUS 7.6
Windows 2000
Output: HTML, PDF
 
Posts: 72 | Registered: January 14, 2008Report This Post
FrankDutch
Virtuoso
posted Hide Post
L_G

I would suggest to find your nearest IBI office and book a starter course.

"Manipulate" master files ? Why?

Just start with some basic reports on the CAR database.
You ask something on Developer Studio and you read the Maintain manual. It's like starting Excel on your PC and read the helpfile for Powerpoint.




Frank
prod: WF 7.6.10 platform Windows,
databases: msSQL2000, msSQL2005, RMS, Oracle, Sybase,IE7
test: WF 7.6.10 on the same platform and databases,IE7

 
Posts: 2387 | Location: Amsterdam, the Netherlands | Registered: December 03, 2006Report This Post
L_G
Gold member
posted Hide Post
Thanks for the answer FrankDutch

I have created a simple report that joins two tables(synonyms) and print some fields.

I need to find a flexible way to cultivate the tables (synonyms) data.



For example if you have the following tables:

EMPLOYEE
----------------
id
names
salary
type_id

EMPLOYEE_TYPE
----------------
id
type
description


I want to create another table(synonyms) that will be used as output for the report:

RESULT
--------------
employee_name
employee_type
salary
(and some other column that is not related to the EMPLOYEE and TYPE tables)


I know that I can join the tables and to use some Temporary field to create this report but I want to bring out the logic...

I hope the information above is not confused...


WebFOCUS 7.6
Windows 2000
Output: HTML, PDF
 
Posts: 72 | Registered: January 14, 2008Report This Post
GinnyJakes
Expert
posted Hide Post
I'm sorry but it is confusing. If you've already done the join and the table, you can hold the data and join it to something else.

JOIN ID IN EMPLOYEE TO ALL ID IN EMPLOYEE_TYPE AS J1
TABLE FILE EMPLOYEE
PRINT SALARY
... Don't know where your other columns are coming from but you might need another join.
BY EMPLOYEE_NAME
BY EMPLOYEE_TYPE
END

Please clarify your requirements.

Frank is correct. You need to read the "Developing Reports with the WebFOCUS Language" manual, not the MAINTAIN manual.

There used to be a FOCUS Primer book years ago. I wonder if it is still available.... It was a great tool to show off the basics of the language.


Ginny
---------------------------------
Prod: WF 7.7.01 Dev: WF 7.6.9-11
Admin, MRE,self-service; adapters: Teradata, DB2, Oracle, SQL Server, Essbase, ESRI, FlexEnable, Google
 
Posts: 2723 | Location: Ann Arbor, MI | Registered: April 05, 2006Report This Post
L_G
Gold member
posted Hide Post
That is what I am trying to say, this additional column should be added by some external code.


I need to migrate reports from AS (it is old reporting system) to WebFocus. This AS reports used very strange logic. They convert many tables into one table, adds columns, deletes columns and so on. I need to observe this logic.

Could you tell me please, what Maintain is used for?

Thanks


WebFOCUS 7.6
Windows 2000
Output: HTML, PDF
 
Posts: 72 | Registered: January 14, 2008Report This Post
FrankDutch
Virtuoso
posted Hide Post
Maintain is used for updating your database by user input.
You can build screens that ask for data and behind the screen you can do calculations before they are send to the database. (that's just one function)




Frank
prod: WF 7.6.10 platform Windows,
databases: msSQL2000, msSQL2005, RMS, Oracle, Sybase,IE7
test: WF 7.6.10 on the same platform and databases,IE7

 
Posts: 2387 | Location: Amsterdam, the Netherlands | Registered: December 03, 2006Report This Post
L_G
Gold member
posted Hide Post
Thanks for your help.

Do you know whether it is possible to manipulate the data in another way?


WebFOCUS 7.6
Windows 2000
Output: HTML, PDF
 
Posts: 72 | Registered: January 14, 2008Report This Post
GinnyJakes
Expert
posted Hide Post
quote:
They convert many tables into one table, adds columns, deletes columns and so on. I need to observe this logic.

You can do all of this with DEFINE, COMPUTE, and HOLD files.

If you give us more detail, we might be better able to help.


Ginny
---------------------------------
Prod: WF 7.7.01 Dev: WF 7.6.9-11
Admin, MRE,self-service; adapters: Teradata, DB2, Oracle, SQL Server, Essbase, ESRI, FlexEnable, Google
 
Posts: 2723 | Location: Ann Arbor, MI | Registered: April 05, 2006Report This Post
L_G
Gold member
posted Hide Post
I will try to describe the Life-cycle of AS reports.

First AS joins 2 tables (EMPLOYEES and EMPLOYEE_TYPE) AND the output of those tables is stored to another table. After that AS make some calculations and adds new row to the output table. After the row is added it renames the table's columns. When this transformation is completed the AS use the output table to Print report


WebFOCUS 7.6
Windows 2000
Output: HTML, PDF
 
Posts: 72 | Registered: January 14, 2008Report This Post
GinnyJakes
Expert
posted Hide Post
This all sounds doable. Can you describe more fully what the additional calculations are and where the data for those calculations come from?

In WF, you can create what is called a HOLD file from the output of the join, then append data to that file, and then do another report where you use the phrase PRINT FIELDNAME AS 'XXXX' to rename the columns.


Ginny
---------------------------------
Prod: WF 7.7.01 Dev: WF 7.6.9-11
Admin, MRE,self-service; adapters: Teradata, DB2, Oracle, SQL Server, Essbase, ESRI, FlexEnable, Google
 
Posts: 2723 | Location: Ann Arbor, MI | Registered: April 05, 2006Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic


Copyright © 1996-2020 Information Builders