Re: Bulk updates from a file

In <1993Oct1.184306.17853@infonode.ingr.com> jjolly@jjolly.b24a.ingr.com (Jack Jolly) writes: >Is there a way to do bulk updates of a table (not inserts) >from a file. A table has 5 columns, 3 of which are filled No, not directly. >in by one application. From another (foreign) db, an >ascii file is made containing the data for the other >two columns. What I need is something like dbload, but >that does updates to selected columns rather than inserts. Not something that is easy to do with a utility, because people's requirements for how to deal with events that "shouldn't" happen (eg duplicate row, missing row etc) vary too widely. >Any ideas?? You could write yourself such a something. Alternatively you could dbload into a "temporary" table and control your own merge with SQL (which is what most people do). graeme -- Disclaimer: The author's opinions are his own, and not necessarily those of Pyramid Technology Ltd. or Pyramid Technology Inc. --------------------------------------------------------------------------- -m------- Graeme Sargent Voice: +44 (0)252 373035 ---mmm----- Senior Database Consultant Fax : +44 (0)252 373135 -----mmmmm--- Pyramid Technology Ltd. Telex: Tell who??? -------mmmmmmm- Farnborough, Hants GU14 7PL Email: graeme@pyra.co.uk --------------------------------------------------------------------------- We have the technology. The tricky bit is learning how to use it.