topic Dynamic table name in native sql in Application Development and Automation Discussions

Dynamic table name in native sql

Former Member — Wed, 11 Nov 2009 03:46:48 GMT

Hi,

is it possible to use dynamic table in native sql.

For eq.

v_tab = 'tdtab'.

exec sql.

select donum into :v_donum

from (v_dtab)

where type = 'abc'.

endexec.

i tried this it is not wrking..how can i achieve this?

Former Member — Wed, 11 Nov 2009 05:08:01 GMT

Hello Arun,

Check following thread for more details:

Hope this will help resolve your problem.

Thanks,

-Augustin.

Search SDN before you POST !!