topic Re: dynamic native sql error in Application Development and Automation Discussions

dynamic native sql error

Former Member — Fri, 29 Jun 2007 01:33:11 GMT

Hi,everyone:

Now I need to insert 60 sap-tables into A table not in sap DB ,according to a formula.so i need to use dynamic native sql, but i find it can not work.

a test example as follow: just as native sql in sap server.

TABLES mara.

DATA: l_matnr LIKE mara-matnr.

DATA: string(1000).

CONCATENATE 'SELECT matnr FROM MARA INTO :L_MATNR WHERE MATNR ='

'''27101921000'''

INTO string

SEPARATED BY space.

EXEC SQL.

:STRING

ENDEXEC.

WRITE: l_matnr.

system return :

SQL error "-104" occurred when executing EXEC SQL.

I wonder the right use of dynamic native sql .

Message was edited by:

Leibnitz.Pan

Re: dynamic native sql error

Former Member — Fri, 29 Jun 2007 01:39:11 GMT

Check with below links :

http://help.sap.com/saphelp_nw04/helpdata/en/af/9373757f30e148b7548b5d8c3d298a/frameset.htm

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/2e81685c-0701-0010-0eb3-918c6d56783a

Thanks

Seshu

Re: dynamic native sql error

Former Member — Fri, 29 Jun 2007 02:14:25 GMT

It's Seems no use for me

thanks a lot.