Dynamic table name in native sql

[Former Member]

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]

Hello Arun,

Check following thread for more details:

Hope this will help resolve your problem.

Thanks,

-Augustin.

Search SDN before you POST !!