Is there a way to union synonyms in the synonym editor

[Erin Trotter]

Is there a way to create a synonym that unions multiple synonyms in the synonym editor?  I have a huge table that has been broken up into smaller chunks to be loaded, but I need to report off of the entire thing for multiple reports. I'm using WebFocus 9.1.1

[Twanette Jurd]

Hi Erin, What is the format of the data? e.g. XFOCUS file, fixed-format text file or RDBMS like MS SQL Server.

[Erin Trotter]

Right now they are binary files, but if it works with a different type of file and not that one, I can do that instead

[Twanette Jurd]

Hi Erin,

If you have multiple "binary" files that have the same structure/format, then you could perhaps concatenate them with the FILEDEF command e.g.

The following commands concatenate the three files.

FILEDEF FILE1 DISK app1/file1.ftm

FILEDEF FILE2 DISK app1/file2.ftm

FILEDEF FILE3 DISK app1/file3.ftm

FILEDEF FILE1 CONCAT FILE2 FILE3

The following procedure issues a request against the concatenated files.

TABLE FILE FILE1

SUM COGS_US REVENUE_US

BY STATE_PROV_NAME

ON TABLE SET PAGE NOPAGE

ON TABLE SET STYLE *

GRID=OFF, SIZE=8,$

END

Server Administration

241