topic Re: Native SQL in Application Development and Automation Discussions

Native SQL

Former Member — Mon, 19 Jan 2009 08:00:15 GMT

I have one internal table which was processed and there is some change in one filed. Now I want to place these changes back into the database table.

Now as I told u previously to establish link between SAP table and legacy system connection between the table and dictionary has been dropped so I need to write Native SQL there. Such as

 

Loop at t_table into fs_table.

 

Exec sql.

   Update database_table_name

         Set changed_field_name = fs_table-changed_field_name

     Where filed = fs_table-field

Endexec.

If I give like this it is going to dump.

If I give values then it is working such as



Exec sql.

 

   Update database_table_name

         Set changed_field_name = u201812345u2019

     Where filed = u2018XYZu2019

 

Endexec.

But if I give variables it is not working, let me know what I can do

Re: Native SQL

Former Member — Mon, 19 Jan 2009 08:17:58 GMT

HI,

What is the data type of fs_table-changed_field_name & fs_table-field.?

Have you ascertained that the variables are correctly filled during execution?

Re: Native SQL

Former Member — Mon, 19 Jan 2009 08:18:16 GMT

copy_pasted_from

http://help.sap.com/saphelp_nw70/helpdata/en/fc/eb3b8b358411d1829f0000e829fbfe/content.htm

Edited by: Vijay Babu Dudla on Jan 19, 2009 5:25 AM

Re: Native SQL

Former Member — Mon, 19 Jan 2009 08:22:08 GMT

hi,

in open sql you will check the type of repository structure

in similier .. check the datatype of the base database as

wen you use opensql it directly likes to the database so give the type of bothe variables fs_table-changed_field_name & fs_table-field as same

shiva

Re: Native SQL

Former Member — Mon, 19 Jan 2009 09:11:46 GMT

Hi Thanks a lot,

My problem got solved....

Re: Native SQL

Former Member — Thu, 21 May 2009 12:09:26 GMT

Can you please tell me what is the solution ..

I am facing the same problem

Regards,

Amit Teja V