Focal Point
Limitation of Match file ??????

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/9891018331

December 15, 2004, 12:07 AM
Ringo
Limitation of Match file ??????
I would like to know if there is limitation of Match function. Since I have 100 tables needs to match together.

URGEN !!!
December 15, 2004, 11:24 AM
Carol Dobson
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.

Good Luck!
Carol
December 15, 2004, 11:31 AM
Piipster
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?
December 15, 2004, 12:11 PM
Piipster
BTW, are you using FOCUS or WebFOCUS?

As of iWay 532 the limit for data sources in a match has increased to 16.

http://techsupport.informationbuilders.com/ibase/master...snf53/rep_lang22.htm

I am not sure of the FOCUS release this was applied to but the more recent release allow 16 files in MATCH.
December 15, 2004, 01:23 PM
Ringo
Thanks guys,
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
SUM
FIELD1 OVER
FIELD2 OVER
FIELD3 OVER
FIELD4 OVER
FIELD5 OVER
FIELD6 OVER
FIELD7 OVER
FIELD8 OVER
...
FIELD98 OVER
FIELD99 OVER
FIELD100
BY FIELDX NOPRINT
BY FIELDY NOPRINT
BY FIELDZ NOPRINT
ACROSS FIELDA AS ''
COLUMNS
'JAN' AND
'FEB' AND
'MAR' AND
'APR' AND
'MAY' AND
'JUN' AND
'JUL' AND
'AUG' AND
'SEP' AND
'OCT' AND
'NOV' AND
'DEC'
END


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 Mad Mad Mad Confused Confused Confused

ANY SUGGESTION, PLEASE ! Frowner Frowner


TABLE FILE FIELD1
PRINT
JAN
FEB
MAR
APR
MAY
JUN
JUL
AUG
SEP
OCT
NOV
DEC
BY FIELDX
BY FIELDY
BY FIELDZ
END

This message has been edited. Last edited by: <Mabel>,
December 15, 2004, 04:35 PM
susannah
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
MORE
FILE1
MORE
FILE3
-etc
This is all quite easy.
But your post is titled 'match' and this problem has nothing to do with 'match'.
December 15, 2004, 11:31 PM
Ringo
Thanks Susannah,

I have 100 tables with the same format field, Now, I would like to generate one report with 100 tables.

What can I do ?