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. Moving forward, myibi is our community platform to learn, share, and collaborate. We have the same Focal Point forum categories in myibi, so you can continue to have all new conversations there. If you need access to myibi, contact us at myibi@ibi.com and provide your corporate email address, company, and name.
I've got two tables; one with current data and one with historical data. The structure is almost identical (98%).
At this moment I'm using the match function to report out of both tables; but matching is a bit slow. I can't join them because the current data and historical data have no relation.
Does anybody have a better idea to make one table out of these two?
Posts: 454 | Location: Europe | Registered: February 05, 2007
OK thaks for your input. I've created 2 new masterfiles with identical tables.
I've made this: -* File more.fex TABLE FILE ORDERHIST PRINT ORDERNR VOLGNR BY DOSVOLG MORE FILE ORDER WHERE (OPDRDEB EQ 123290) ON TABLE NOTOTAL ON TABLE SET HTMLCSS ON END
I'm getting this error:
0 ERROR AT OR NEAR LINE 10 IN PROCEDURE more FOCEXEC * (FOC953) INVALID STRUCTURE IN SUBREQUEST: ON BYPASSING TO END OF COMMAND
I'm running WebFOCUS 7.6 an a IBM Universe 10.2 database (multivalue)
TABLE FILE ORDERHIST PRINT ORDERNR VOLGNR BY DOSVOLG MORE FILE ORDER WHERE (OPDRDEB EQ 123290) ON TABLE NOTOTAL ON TABLE SET HTMLCSS ON END
When using MORE, I always HOLD, then report. Put a semi-colon after the WHERE... I assume OPDRDEB is an Integer column; if not, put quotes around 123290 Your ORDER file must be SORTed and all columns the same as in the ORDERHIST file:
TABLE FILE ORDERHIST PRINT ORDERNR VOLGNR BY DOSVOLG ON TABLE HOLD MORE FILE ORDER PRINT ORDERNR VOLGNR BY DOSVOLG WHERE (OPDRDEB EQ 123290); END -RUN TABLE FILE HOLD PRINT * ON TABLE NOTOTAL ON TABLE SET HTMLCSS ON END -EXIT
You did not tell us what kind of table this are. If it p.e is in SQL you can start with a union select in SQL and use that view for building your master.
In that case you only have one tabel select.
Frank
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, 2006