Re: field compares on table across multiple servers

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