Re: Table lookup function in isql?

In article <1992Apr7.180849.13196@informix.com> proberts@informix.com (Paul Roberts) writes: >In article <62980009@col.hp.com> judym@col.hp.com (Judy Miller) writes: >>Question: Is there some kind of table lookup feature in isql >> (Informix SQL Query Language)? >> >>Problem: I have a list of keys to 4000 records which I need to delete from >> a table of 12000. >> >>I'm trying to avoid writing a program for this common function. >>(I do not have 4GL on this machine, but I do have ESQL/C.) >> >>Another option is to unload the table and eliminated the records outside of >>Informix, delete all, and then reload the remaining two-thirds. >> >>Judy > >(sorry if this gets posted twice) > >What I tend to do is write a script that will generate a script that >will do the deletes. Not too elegant, but it works well. > >[...] > >You can use variations on this method to do all sorts of mass-updates/ >deletes to large tables. > >Paul > I see now that there is a much easier way to do this. Still, my method is good when the delete (or update) condition is more complex, i.e. can't be represented simply by "in <some list>".