I would like to know if there is limitation of Match function. Since I have 100 tables needs to match together.
I think there's a limit of 6 files at one time!
However, once you have 6 files from a match in a hold file you can then match that hold file to 5 more files.
However, Matches are not very efficient. You should try to join a few files at a time to produce hold files and keep working from there.
Is this a one-time effort, or something you will do on a regular basis?
What is the datasource?
Can you use relational views to join some of your source tables together?
What is your objective of matching so many tables?
BTW, are you using FOCUS or WebFOCUS?
As of iWay 532 the limit for data sources in a match has increased to 16.
I am not sure of the FOCUS release this was applied to but the more recent release allow 16 files in MATCH.
Actually, I used the function -Across column in terms of no of columns and verb objects. It worked fine when the FIELD is UP to 94, But I do need the FIELD Up to 100. I am getting an error (Topic: Limitation of Across, posted at 08 December, 2004 21:51)
(FOC153) VERB OBJECTS TIMES RETRIEVED COLUMNS EXCEEDS MAXIMUM
TABLE FILE EXAMPLE
BY FIELDX NOPRINT
BY FIELDY NOPRINT
BY FIELDZ NOPRINT
ACROSS FIELDA AS ''
Other members suggest that it needs to seperate them into the table format as below. Then, Use the MATCH FILE function to match FIELD1 ..... FIELD100. Crazy
ANY SUGGESTION, PLEASE !
TABLE FILE FIELD1
This message has been edited. Last edited by: <Mabel>,
This sounds like a perfect FML application.
However, if you dont want to use FML,
then do 1 across with 12 months (use smart dates and you won't have to manually order the columns)
and make each one of your concepts (the 'over' fields) a separate file which you concat when you read with a MORE command.
Order them, in the order you want in your report.
Use an integer field with an incrementing value for each of the separate files.
Use a single variable in each of the files to contain the concept name as you would want it printed in your final report.
Use a loop thru a list of concept names when you create the 100+ individual temp files,
Use the same loop construct when you read them using MORE
Then your final report is
TABLE FILE FILE1
SUM thing ACROSS MONTH
BY ORDER NOPRINT BY CONCEPT
This is all quite easy.
But your post is titled 'match' and this problem has nothing to do with 'match'.
I have 100 tables with the same format field, Now, I would like to generate one report with 100 tables.
What can I do ?
|Powered by Social Strata|