Using Variable tab name for a select

Former Member — Thu, 30 Jul 2009 11:51:31 GMT

Hi,

I need to do a select from a two different tables controled by system date.

I try to do the following for example:

Data: tabela type tabname.

if l_data ge '01012009'

tabela = 'zxx_new'

else.

tabela = 'zxx_old'

endif.

Select * from tabela

where ...

It's possible using Select statement this way ? or i need to do...

if l_data ge '01012009'

select * from zxx_new ...

else.

select * from zxx_old ...

endif.

Thanks,

Re: Using Variable tab name for a select

MarcinPciak — Thu, 30 Jul 2009 12:01:29 GMT

Almost ok, should be:


if l_data ge '01012009'
tabela = 'zxx_new'
else.
tabela = 'zxx_old'
endif.

Select * from (tabela)   "here you determine table dynamicaly  by giving its name
where ...

Regards

Marcin

topic Re: Using Variable tab name for a select in Application Development and Automation Discussions

Using Variable tab name for a select

Re: Using Variable tab name for a select