Is there any way to make variable CALL in Informix 4GL, ie. calling
functions depending on results of SELECT statement?
What am I trying is:
DEFINE p_func_name CHAR(10)
SELECT func_name INTO p_func_name FROM functions WHERE ....
CALL p_func_name()
instead of
DEFINE p_func_name CHAR(10)
SELECT func_name INTO p_func_name FROM functions WHERE ....
CASE p_func_name
WHEN "T100"
CALL T100()
WHEN "T101"
CALL T101()
......
END CASE
↪ replying to remove (at) to reply (at)
On Tue, 18 Apr 2000 08:41:29 +0200, "remove (at) to reply"
<mips(at)@zg.tel.hr> wrote:
>Is there any way to make variable CALL in Informix 4GL, ie. calling
>functions depending on results of SELECT statement?
>
>What am I trying is:
>
> DEFINE p_func_name CHAR(10)
>
> SELECT func_name INTO p_func_name FROM functions WHERE ....
> CALL p_func_name()
>
>instead of
>
> DEFINE p_func_name CHAR(10)
>
> SELECT func_name INTO p_func_name FROM functions WHERE ....
> CASE p_func_name
> WHEN "T100"
> CALL T100()
> WHEN "T101"
> CALL T101()
> ......
> END CASE
I think no. Only way is
1) RUN "other.4ge"
2) PREPARE and EXECUTE spl procedure
--
Jiří Lisický ČD DATIS Olomouc
e-mail: lisicky@datis.cdrail.cz Nerudova 1
phone: +420-068-472-5496 Olomouc, Czech Republic
>>> čeština ISO-8859-2 Compatible <<<