Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
SBradChef — — source: Informix-list mailing list archive (1991-1998)
Try putting the delete inside a loop like this:
let scratch =
"select key from sometable"
prepare sel1 from scratch
decalre cur1 cursor for sel1
let scratch =
"delete ",
" from sometable ",
" where key = ? "
prepare del1 from scratch
foreach cur1 into var1
execute del1 using var1
end foreach
Your privacy choices
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.