Erin Trotter Posted March 24, 2023 Share Posted March 24, 2023 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 Link to comment Share on other sites More sharing options...
Twanette Jurd Posted March 24, 2023 Share Posted March 24, 2023 Hi Erin, What is the format of the data? e.g. XFOCUS file, fixed-format text file or RDBMS like MS SQL Server. Link to comment Share on other sites More sharing options...
Erin Trotter Posted March 24, 2023 Author Share Posted March 24, 2023 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 Link to comment Share on other sites More sharing options...
Twanette Jurd Posted March 24, 2023 Share Posted March 24, 2023 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.ftmFILEDEF FILE2 DISK app1/file2.ftmFILEDEF FILE3 DISK app1/file3.ftmFILEDEF FILE1 CONCAT FILE2 FILE3The following procedure issues a request against the concatenated files.TABLE FILE FILE1SUM COGS_US REVENUE_USBY STATE_PROV_NAMEON TABLE SET PAGE NOPAGEON TABLE SET STYLE *GRID=OFF, SIZE=8,$ENDServer Administration 241 Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now