Re: need help with isql and informix

This won't work.. because some records are updates and already exsit.. } From: Bill Ennis <ennis@ssax.com> } Subject: Re: need help with isql and informix } To: tony@toners.com } Date: Thu, 19 Dec 96 8:38:05 CST } Cc: informix-list@rmy.emory.edu } 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 } }