Re: need help with isql and informix

Tony Reeves (areeves@goodnet.com) wrote: { 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.. Create another table with the exact same field names/types/sizes as the one to be updated. Load the records to the new table, Using what ever criteria makes the record identifyable, write one script that inserts and another that updates. -- gburnore@databasix.com mailto:gburnore@databasix.com --------------------------------------------------------------------------- What do you ship styrofoam in? --------------------------------------------------------------------------- Gary L. Burnore | '۳''''''۳'''''''''''۳ DataBasix | '۳''''''۳'''''''''''۳ San Francisco, CA | '۳''''''۳'''''''''''۳ | '۳ 3 4 1 4 2 '' 6 9 0 6 9 '۳ http://www.databasix.com | Official Proof of Purchase ===========================================================================