Run report from two different servers.

[focuscandoanything]

I have two exact same files on two different servers. One is history the other is current. I want to run a report that accesses both data files and gets one output report.

 

[FOCMAN]

How are you configured? Are there 2 separate WebFOCUS Servers? Are they configured to see each other? What is the file type you are reading?

 

[mrguru]

Quick and dirty:

table the first file and 'hold' to a hold file
filedef the hold file with append
table the second file and 'save' to the hold file
report off the hold file

ie:
table file car
print country
on table hold as hcar
end

filedef hcar disk hcar.ftm (append

table file car2
print country
on table save as hcar
end

table file hcar
print country
end

 

[focwizard]

Actually, the MORE command (under Universal Concatenation) was designed to do exactly that, report off two or more potentially different files and produce a suingle output.