Informix and firewalls

well i want to query an Informix database from the internet and I do need to secure it before I do any thing so I have seen something about fire walls and I need help on this one what are fire walls ? how can I use them given perl,cgi,informix and a Unix server? How can I implement them? -----Original Message----- From: Astemborski, Jon [mailto:JAstemborski@biztravel.com] Sent: Monday, October 02, 2000 3:27 PM To: 'informix-list@iiug.org' Subject: Hello everyone, I am trying to update a table based on the contents of another table but only where the primary keys are equal. Because I can not directly reference the non updated table in a from statement it throws off what I want to do. I tried to replicate it with a sub queries but I received error 284 (a query has not returned not exactly one row). I understand the error, but how can I perform a multirow update based on the contents of another table? (I have tried numerous other variations but to no avail) update bizguaranteereq set (occurdate,itineraryid,statuscd,moddate) = ((select a1.creationdate,a1.itineraryid, 99 statuscd, today moddate from incentval a1, biztemp a2 where a1.userid=a2.userid and a1.offercode=a2.servissue and statuscd!=99)) where userid=(select userid from incentval) and servissue=(select offercode from incentval Regards, Jon Astemborski