Re: need help with isql and informix

Hi, In isql: Select Query Lang. load from "filename" insert into <table name> The pipe is the default delimiter, you could override if you had a a different delimiter (such as a comma). Your isp provides an Infomrix engine for you to use? That's a nice benefit - who are they? -BE } } } 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 } } } -- Bill Ennis Voice: 312-474-7516 SSA Fax: 312-474-7460 500 W. Madison email: ennis@ssax.com