Re: Table lookup function in isql?
In-reply-to: Your message of "04 Apr 92 00:14:51 GMT."
<62980009@col.hp.com>
----------------------------------------------------------------
-------- Start of Included Message --------
} 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
--------- End of Included Message ---------
Or load up the list of keys into a table T
and then
Delete from A Where A.x == T.x