Table lookup function in isql?

Posted in 1992

Judy Miller — 4 Apr 92 00:14:51 GMT — source: Informix-list mailing list archive (1991-1998)

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