Insert into external DB using native SQL

[Former Member]

Hi,

Is there any easier way to insert data in to External DB using native SQL insert.

there are 250 columns to be inesrted. table structures in SAP and ext db are same.

Thanks in Advance

Somesh

[Former Member]

Hi,

If you the external DB connected to application server perfectly then we can use EXEC - Native SQL commands.

regards

• DJ

reward, if its useful

[Former Member]

Thanks for the reply DJ.

You are right. the issue i am facing is , is there any simpler way to prepare that native SQL statement using some dynamic statemnts or FM or class to make it work, instead of typing all those 250 columns?

Thanks in Advance

[Former Member]

Hi someswara,

Creating a dynamic statements using Native SQL is a bit tough task. I don't think anyone might have tried it. Instead you can write down the all columns as it is one time activity only, and by the time you will find solution you will be ready with your queries :).

Reward points if useful.

Regards,

Atish

[Former Member]

hard coded all the fields...

[Former Member]

another method is to create a structure with all those fields and use DD function module to prepare a query..