topic Re: Dynamic DB table name in insert statement in Application Development and Automation Discussions

Dynamic DB table name in insert statement

Former Member — Tue, 14 Aug 2007 20:32:03 GMT

In the following command i was able to build <dyn_table> dynamically but how do we do that for <dyn_wa>. table name should be populated dynamically here.

for ex: pa0001, pa0002, .... and I have these names in an IT table

INSERT <dyn_wa> FROM TABLE <dyn_table>

ACCEPTING DUPLICATE KEYS.

Pls help...Thanks

Re: Dynamic DB table name in insert statement

former_member192429 — Tue, 14 Aug 2007 20:35:36 GMT

Try INSERT (Table_name) FROM ....

Where Table_name has Database table name

-Kriss

Re: Dynamic DB table name in insert statement

Former Member — Tue, 14 Aug 2007 20:38:55 GMT

what should be the data type of this 'table_name'??

Re: Dynamic DB table name in insert statement

Former Member — Tue, 14 Aug 2007 20:40:12 GMT

You can use a string type -:)


DATA: table_name type STRING.

Greetings,

Blag.

Re: Dynamic DB table name in insert statement

former_member194669 — Tue, 14 Aug 2007 20:41:38 GMT

Hi,

Try with

data : v_table_name like dd08v-tabname.

aRs

Re: Dynamic DB table name in insert statement

Former Member — Tue, 14 Aug 2007 20:44:16 GMT

data: tab_name type string.

INSERT <dyn_table> into tab_name

ACCEPTING DUPLICATE KEYS.

gives me error " tab_name" is not an internal table.

Re: Dynamic DB table name in insert statement

Former Member — Tue, 14 Aug 2007 20:47:10 GMT

Take it as charater type.

This code works for me.

TABLES : ztest123.

DATA : tab_name(10) TYPE c.

tab_name = 'ZTEST123'.

DATA : wa LIKE ztest123.

wa-name = 'Mahesh'.

INSERT (tab_name) FROM wa.

Thanks

Mahesh

Re: Dynamic DB table name in insert statement

Former Member — Tue, 14 Aug 2007 20:49:10 GMT

check ur syntax of the insert statement

it should insert(tab_name) from table Internaltable.

insert(tab_name)from workarea.

here tab_name is variable contains the name of the DB table

Thanks,

Mahesh

Re: Dynamic DB table name in insert statement

Former Member — Tue, 14 Aug 2007 20:49:13 GMT

in my case both the internal table ( wa) and the db table are dynamic