Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2009
    Posts
    1

    Unanswered: local variable to be used for from in select statment

    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.

  2. #2
    Join Date
    Jan 2010
    Posts
    2
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •