kirt wrote:
>
> hi
>
> I am running 5 servers and need to compare a field to find the largest.
> the tables on the five servers are virtualy identicle except for a select
> few fields.
>
> database names tablenames and fieldnames are identicle on all the machines.
> we are using istar and the tables are being refreshed from each other
> constantly.
> the field i am keying on is an integer field.
> a programmer i'm not but i can write shell scripts if they're not overly
> complex.
How about, assuming you have the sqlhosts entries to allow the
distributed query:
SELECT "Server1", MAX(test_field) FROM database@server1:tablename
UNION ALL
SELECT "Server2", MAX(test_field) FROM database@server2:tablename
UNION ALL
SELECT "Server3", MAX(test_field) FROM database@server3:tablename
UNION ALL
SELECT "Server4", MAX(test_field) FROM database@server4:tablename
UNION ALL
SELECT "Server5", MAX(test_field) FROM database@server5:tablename
;
Art S. Kagel