Re: Informix in WAN - opinions wanted

In article <DGJs7x.83r@softec.sk> steffl@softec.sk (Erik Steffl) writes: >From: steffl@softec.sk (Erik Steffl) >Subject: Informix in WAN - opinions wanted >Date: Mon, 16 Oct 1995 15:26:20 GMT >Hi, everybody, > we are planning information system for about 160 site, >each site has its own LAN with at least one Informix 7 database >server. We need these severs to communicate and share some data, >though batch processing will suffice and data flow will not be >extreme (500 KB or less each day). If we use dial up lines and >Slip protocol (and TCP/IP over it, of course), what Informix >tools should we use? > Is remote access to database tables OK? Is it secure - what >if we update some table and the line goes down - is transaction >usage enough to make our data consistent (to maintain integrity)? > Does anybody have any experiences with such a usage of >Informix database server? Any opinions wanted, since I've heard somewhere >that remote access to databases is not very good supported in Informix, >is that true. > Thanx in advance > bye > erik Why not just save the data you need to transmit in load format, transmit it as text files and load it at the desination. If the data has to update rather than load at the destination load it into an intermediate table and have a program read that and update the destination. Each file transmitted could have a predetermined trailer record for which you could check at the destination in order to validate the transfer. If you were worried about loss in the middle of the file you could check with wc at each end and if you were really paranoid (stringly recomended!) checksum the file. wc or checksum output would be transmitted separately. Ian