 |
|||||
|
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
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 WebFOCUS/FOCUS Forum on Focal Point [CLOSED] Different Months but same MAS file name.
Focal Point Forums WebFOCUS/FOCUS Forum on Focal Point [CLOSED] Different Months but same MAS file name. Read-Only TopicGo | Search | Notify | Tools |
| [CLOSED] Different Months but same MAS file name. | Login/Join |
| Member |
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 | ||
|
| Virtuoso |
What do you mean by "previous 6 months . MAS file" What is in your opinion a MAS file?
| |||||||
|
| Member |
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 | |||
|
| Virtuoso |
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?
| |||||||
|
| Member |
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 | |||
|
| Virtuoso |
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.
| |||||||
|
| Member |
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 | |||
|
| Virtuoso |
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?
| |||||||
|
| Powered by Social Strata |
 | Please Wait. Your request is being processed... |
Read-Only TopicFocal Point Focal Point Forums WebFOCUS/FOCUS Forum on Focal Point [CLOSED] Different Months but same MAS file name.
Focal Point Forums WebFOCUS/FOCUS Forum on Focal Point [CLOSED] Different Months but same MAS file name.Copyright © 1996-2020 Information Builders
| View $GS_USERNAME's Public Profile |
| Add $GS_USERNAME to my Ignore List |
| View Recent Posts by $GS_USERNAME |
| Notify me of New Posts by $GS_USERNAME |