topic Re: Insert into external DB using native SQL in Application Development and Automation Discussions

Insert into external DB using native SQL

Former Member — Thu, 14 Jun 2007 21:08:56 GMT

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

Re: Insert into external DB using native SQL

Former Member — Thu, 14 Jun 2007 21:52:17 GMT

Hi,

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

regards

reward, if its useful

Re: Insert into external DB using native SQL

Former Member — Thu, 14 Jun 2007 22:23:36 GMT

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

Re: Insert into external DB using native SQL

Former Member — Thu, 14 Jun 2007 22:27:02 GMT

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

Re: Insert into external DB using native SQL

Former Member — Mon, 13 Oct 2008 18:06:20 GMT

hard coded all the fields...

Re: Insert into external DB using native SQL

Former Member — Mon, 13 Oct 2008 18:07:24 GMT

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