Re: PLEASE HELP - Dynamic SQL in a stored proc
Miguel Lorenzo Turbon wrote:
>
> We need to build dynamic SQL in the following stored procedure.
>
> create procedure informix.proc(tablename char(20); colname char(20))
> returning char(20);>
> define colvalue char(20);
>
> foreach
> select colname
> ^^^^^^^
> into colvalue
> from tablename
> ^^^^^^^^^
> return colvalue with resume;> end foreach
> end procedure;
>
> Is this possible? What's the correct syntax?
>
> Thanks.
Hi,
it's impossible. The only way is to form a if-else construction.
Bye.
Stefan.
stefan@weideneder.de