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     [CLOSED] Different Months but same MAS file name.

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[CLOSED] Different Months but same MAS file name.
 Login/Join
 
Member
posted
Hi All,
I am new here and hope my question is understand to you.
Within one procedure, can I utilized the previous 6 months .MAS file which have the same name?
Thanks all.

This message has been edited. Last edited by: Kerry,


WebFocus 7.1
WindowXP
HTML, EXCEL & PDF
 
Posts: 4 | Registered: February 25, 2009Report This Post
Virtuoso
posted Hide Post
What do you mean by "previous 6 months . MAS file"
What is in your opinion a MAS file?




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
Member
posted Hide Post
Each month all sale transactions, amount and customer information, etc. will be downloaded and was saved within a certain database name eg. CarSell_Jul08, Carsell_Aug08, Carsell_Sep08, Carsell_Oct08, Carsell_Nov08 and Carsell_Dec08. Among it, there are serveral different subfiles and the subfiles name is the same for each month, which look like this.
Carsell_Jul08
- customer.mas
- newcar.mas
- hirecar.mas
Carsell_Aug08
- customer.mas
- sellcar.mas
- hirecar.mas
Carsell_Sep08
- customer.mas
- sellcar.mas
- reccard.mas
Carsell_Oct08
- customer.mas
- sellcar.mas
- reccar.mas
Carsell_Nov08
- customer.mas
- sellcar.mas
- reccar.mas
Carsell_Dec08
- customer.mas
- sellcar.mas
- reccar.mas

Base on this struction, can I use one procedure (.FEX file) to join all six months information and list them out even though they all have the same MAS name?


WebFocus 7.1
WindowXP
HTML, EXCEL & PDF
 
Posts: 4 | Registered: February 25, 2009Report This Post
Virtuoso
posted Hide Post
Well it can, take the documentation and search for the term 'USE'.

I think however that your design is a bit strange.
If you put and extra field in the database masters that has the month as key, you may be able to put all the data into one database.

If you post the 3 masters we might be able to help you a bit better.
I suppose you have all the databases in different directories?
What kind of databases are this?




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
Member
posted Hide Post
quote:
you post the 3 masters we might be able to help you a bit better.
I suppose you have all the databases in different directories?

Thanks for your help, but due to company policy, the data cannnot be disclosed. Any way try your suggestion.


WebFocus 7.1
WindowXP
HTML, EXCEL & PDF
 
Posts: 4 | Registered: February 25, 2009Report This Post
Virtuoso
posted Hide Post
I did not ask for the data, but for the masters.

The best suggestion I can think of is ask the company what there policy is in relation to training there personnel.
I think they bought a very good and powerful piece of software.




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
Member
posted Hide Post
Hi Frank
As I am the end user and are very very new to WebFocuc. Sorry for the miss leading, hope this will make you more clear .
**CREATE SYNONYM**
****LEDF COLUMN****
Metadata
Configured
approot
DEC2008
sel940 - ODBC
sellown - ODBC
carhire - ODBC

Add
Remote Server

ODBC
DEC2007
JUN2008
JUL2008
OCT2007
NOV2007
SEP2008
JAN2008
DEC2008

***RIGHT CLOUMN***

DBMS = SQLODBC ; Server = DEC2008
Application: DEC2008
Prefix: SET CONVERSION LONGCHAR TEXT (for Web Focus)ALPHABLOB (for EDA)
--------------------------------------------------------------------------------
All Select
Check Default Synonym Name Owner/Schema Table Name Type
SELL940 dbo SELL940 TABLE
SELLOWN dbo SELLOWN TABLE
CARHIRE dbo CARHIRE TABLE


WebFocus 7.1
WindowXP
HTML, EXCEL & PDF
 
Posts: 4 | Registered: February 25, 2009Report This Post
Virtuoso
posted Hide Post
I would again strongly recommend at least some basic training.

Your company gives you as enduser the ability to create synonyms, but who is creating all the databases every month?

If you open the CARHIRE.MAS of one of these months in an editor what do you get?
Does the master have a field to recognize the month?




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
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] Different Months but same MAS file name.

Copyright © 1996-2020 Information Builders