Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     Limitation of Match file ??????
Go
New
Search
Notify
Tools
Reply
  
Limitation of Match file ??????
 Login/Join
 
Gold member
posted
I would like to know if there is limitation of Match function. Since I have 100 tables needs to match together.

URGEN !!!
 
Posts: 55 | Registered: May 15, 2004Reply With QuoteReport This Post
Guru
posted Hide Post
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
 
Posts: 428 | Location: Springfield, MA | Registered: May 07, 2003Reply With QuoteReport This Post
Guru
posted Hide Post
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?
 
Posts: 346 | Location: Melbourne Australia | Registered: April 15, 2003Reply With QuoteReport This Post
Guru
posted Hide Post
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.
 
Posts: 346 | Location: Melbourne Australia | Registered: April 15, 2003Reply With QuoteReport This Post
Gold member
posted Hide Post
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>,
 
Posts: 55 | Registered: May 15, 2004Reply With QuoteReport This Post
Expert
posted Hide Post
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'.
 
Posts: 3811 | Location: Manhattan | Registered: October 28, 2003Reply With QuoteReport This Post
Gold member
posted Hide Post
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 ?
 
Posts: 55 | Registered: May 15, 2004Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     Limitation of Match file ??????

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.