Skip to Content
0
Former Member
Jul 22, 2008 at 08:32 PM

Read table, table name in variable

1964 Views

Hi all,

I am try trying to do the following.

Select statement to get the table name --> store in tname (variable).

Now, I have to do a select to read the data in this table (table name is in tname variable) based on some conditions

How do I do this?

1st step

Select ME_TECH from RSAC into tname

where NAME = 'PLANT'

and DATEFROM <= ldate

and DATETO >= ldate.

2nd step??

..........................................?

Thanks,

Anirudh.