need help with isql and informix
Posted in 1996
Topics: General Discussion
I'm using a informix database to store some product data on a isp's server.. I am getting very little help from their support team.. can someone help with this problem.. I need to update records that have changed since I loaded the database. I have a flat file that contains about 10 records that are delimited by a pipe '|' and I want to use it to either update or add the record if the record is not there. I have looked through the manuals I have on informix and tryed a few things with isql, none have worked.. it appears that update command does not have a syntax to read a file and that load does not do a modify of a record.. In other sql's I have used a load would either update an exsiting record or add if its not there.. How can I take my 10 records - using isql, and issue a load or update and have them inserted into the database? I have access to isql, perl and csh.. --- Tony Reeves AB6GA - areeves@goodnet.com, tony@toners.com - HF: 14.242Mhz or 28.480Mhz Environmental Laser - Quality Laser/Copier Toner Cartridge re-manufacture Homepage: http://www.toners.com