Hi all,

I have declared one variable in my procedure
DEFINE trans_table varchar(32);

then storing different table name in this variable using

FOREACH WITH HOLD SELECT tabname INTO trans_table FROM systables
WHERE tabname like 'trans_cache_s01_%'

Now I am trying to do

SELECT min(trans_t),max(trans_t) INTO min_trans_t, max_trans_t FROM $trans_table;

but getting error

An illegal character has been found in the statement.

tried different combination like '$trans_table' or "$trans_table" but none worked out.

An illegal character has been found in the statement.

tried different combination like '$trans_table' or "$trans_table" but none worked out.
Reply With Quote

Watch Free Film Online |
Watch Avatar movie online free