Unanswered: Dropping a constraing in a procedure using a variable
I'm very new to Informix.
There is a req. to drop a index whose name is not known. We have created a procedure and by using a query we are selecting the constraint name into a variable inside the procedure. If this variable is used in drop constraint statement its not accepting that (variable name is l_cnt)
select constrname into l_cnt from sysconstraints a, syschecks b where a.constrid = b.constrid
and b.type = 'T' and b.checktext like "(acct_cnst IN %";
drop constraint (l_cnt)
Any inputs how to execute a srop constraint statement with dynamically available constraint name.